[belajar-excel] Mohon pencerahannya kembali para suhu [1 Attachment]

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

[belajar-excel] Mohon pencerahannya kembali para suhu [1 Attachment]

7 hari menuju Perubahan
Soal yg pertama sdh closed namun timbul masalah baru angka pd "qty total"
yg merupakan "angka index produksi" tidak sama (file terlampir), mohon maaf
para suhu mhn pencerahannya kembali.

Nunuh S

--
Regards,


Nunuh Sumanta
+6281383249999,
[hidden email]

Soal Be-Excel lanjutan_Monitoring Pintu Besi update Surat Jalan.xlsx (146K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Mohon pencerahannya kembali para suhu

Agus-2
Dear Nunuh,
Coba di C9, diganti formula lookup menjadi:
=VLOOKUP(B9,Index!$B$2:$C$42,2,0)

Kopi ke bawah.
Jangan lupa apabila regional settingnya bahasa Indonesia diubah , menjadi ;
Regard
Agus
On 10/4/2019 21:15, 7 hari menuju Perubahan [hidden email]
[belajar-excel] wrote:

> Soal yg pertama sdh closed namun timbul masalah baru angka pd "qty
> total" yg merupakan "angka index produksi" tidak sama (file
> terlampir), mohon maaf para suhu mhn pencerahannya kembali.
>
> Nunuh S
>
> --
> Regards,
>
>
> Nunuh Sumanta
> +6281383249999,
> [hidden email] <mailto:[hidden email]>
>
>
>
>


Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Mohon pencerahannya kembali para suhu [1 Attachment]

Sandy-2
In reply to this post by 7 hari menuju Perubahan
Saya sudah lama meninggalkan VLOOKUP karena rentan jika table source nya tidak urut.Lebih baik pake INDEX & MATCH
Sandy

    On Saturday, October 5, 2019, 04:58:08 AM GMT+8, 7 hari menuju Perubahan [hidden email] [belajar-excel] <[hidden email]> wrote:

  

Soal yg pertama sdh closed namun timbul masalah baru angka pd "qty total" yg merupakan "angka index produksi" tidak sama (file terlampir), mohon maaf para suhu mhn pencerahannya kembali.
Nunuh S
--
Regards,


Nunuh Sumanta
+6281383249999,
[hidden email]



  #yiv7018468474 #yiv7018468474 -- #yiv7018468474ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7018468474 #yiv7018468474ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7018468474 #yiv7018468474ygrp-mkp #yiv7018468474hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv7018468474 #yiv7018468474ygrp-mkp #yiv7018468474ads {margin-bottom:10px;}#yiv7018468474 #yiv7018468474ygrp-mkp .yiv7018468474ad {padding:0 0;}#yiv7018468474 #yiv7018468474ygrp-mkp .yiv7018468474ad p {margin:0;}#yiv7018468474 #yiv7018468474ygrp-mkp .yiv7018468474ad a {color:#0000ff;text-decoration:none;}#yiv7018468474 #yiv7018468474ygrp-sponsor #yiv7018468474ygrp-lc {font-family:Arial;}#yiv7018468474 #yiv7018468474ygrp-sponsor #yiv7018468474ygrp-lc #yiv7018468474hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7018468474 #yiv7018468474ygrp-sponsor #yiv7018468474ygrp-lc ...yiv7018468474ad {margin-bottom:10px;padding:0 0;}#yiv7018468474 #yiv7018468474actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7018468474 #yiv7018468474activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7018468474 #yiv7018468474activity span {font-weight:700;}#yiv7018468474 #yiv7018468474activity span:first-child {text-transform:uppercase;}#yiv7018468474 #yiv7018468474activity span a {color:#5085b6;text-decoration:none;}#yiv7018468474 #yiv7018468474activity span span {color:#ff7900;}#yiv7018468474 #yiv7018468474activity span .yiv7018468474underline {text-decoration:underline;}#yiv7018468474 .yiv7018468474attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv7018468474 .yiv7018468474attach div a {text-decoration:none;}#yiv7018468474 .yiv7018468474attach img {border:none;padding-right:5px;}#yiv7018468474 .yiv7018468474attach label {display:block;margin-bottom:5px;}#yiv7018468474 .yiv7018468474attach label a {text-decoration:none;}#yiv7018468474 blockquote {margin:0 0 0 4px;}#yiv7018468474 .yiv7018468474bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv7018468474 .yiv7018468474bold a {text-decoration:none;}#yiv7018468474 dd.yiv7018468474last p a {font-family:Verdana;font-weight:700;}#yiv7018468474 dd.yiv7018468474last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7018468474 dd.yiv7018468474last p span.yiv7018468474yshortcuts {margin-right:0;}#yiv7018468474 div.yiv7018468474attach-table div div a {text-decoration:none;}#yiv7018468474 div.yiv7018468474attach-table {width:400px;}#yiv7018468474 div.yiv7018468474file-title a, #yiv7018468474 div.yiv7018468474file-title a:active, #yiv7018468474 div.yiv7018468474file-title a:hover, #yiv7018468474 div.yiv7018468474file-title a:visited {text-decoration:none;}#yiv7018468474 div.yiv7018468474photo-title a, #yiv7018468474 div.yiv7018468474photo-title a:active, #yiv7018468474 div.yiv7018468474photo-title a:hover, #yiv7018468474 div.yiv7018468474photo-title a:visited {text-decoration:none;}#yiv7018468474 div#yiv7018468474ygrp-mlmsg #yiv7018468474ygrp-msg p a span.yiv7018468474yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7018468474 .yiv7018468474green {color:#628c2a;}#yiv7018468474 .yiv7018468474MsoNormal {margin:0 0 0 0;}#yiv7018468474 o {font-size:0;}#yiv7018468474 #yiv7018468474photos div {float:left;width:72px;}#yiv7018468474 #yiv7018468474photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv7018468474 #yiv7018468474photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7018468474 #yiv7018468474reco-category {font-size:77%;}#yiv7018468474 #yiv7018468474reco-desc {font-size:77%;}#yiv7018468474 .yiv7018468474replbq {margin:4px;}#yiv7018468474 #yiv7018468474ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv7018468474 #yiv7018468474ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7018468474 #yiv7018468474ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7018468474 #yiv7018468474ygrp-mlmsg select, #yiv7018468474 input, #yiv7018468474 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv7018468474 #yiv7018468474ygrp-mlmsg pre, #yiv7018468474 code {font:115% monospace;}#yiv7018468474 #yiv7018468474ygrp-mlmsg * {line-height:1.22em;}#yiv7018468474 #yiv7018468474ygrp-mlmsg #yiv7018468474logo {padding-bottom:10px;}#yiv7018468474 #yiv7018468474ygrp-msg p a {font-family:Verdana;}#yiv7018468474 #yiv7018468474ygrp-msg p#yiv7018468474attach-count span {color:#1E66AE;font-weight:700;}#yiv7018468474 #yiv7018468474ygrp-reco #yiv7018468474reco-head {color:#ff7900;font-weight:700;}#yiv7018468474 #yiv7018468474ygrp-reco {margin-bottom:20px;padding:0px;}#yiv7018468474 #yiv7018468474ygrp-sponsor #yiv7018468474ov li a {font-size:130%;text-decoration:none;}#yiv7018468474 #yiv7018468474ygrp-sponsor #yiv7018468474ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv7018468474 #yiv7018468474ygrp-sponsor #yiv7018468474ov ul {margin:0;padding:0 0 0 8px;}#yiv7018468474 #yiv7018468474ygrp-text {font-family:Georgia;}#yiv7018468474 #yiv7018468474ygrp-text p {margin:0 0 1em 0;}#yiv7018468474 #yiv7018468474ygrp-text tt {font-size:120%;}#yiv7018468474 #yiv7018468474ygrp-vital ul li:last-child {border-right:none !important;}#yiv7018468474

Soal Be-Excel lanjutan_Monitoring Pintu Besi update Surat Jalan.xlsx (143K) Download Attachment