Hai Arif,
Bagaimana jika formula :
=INDEX('code customer'!$A$2:$A$52,MATCH(LEFT(A4,2),'code
customer'!$B$2:$B$52,0))
diubah menjadi :
=INDEX('code customer'!$B$2:$B$52,MATCH(LEFT(A4,2),'code
customer'!$A$2:$A$52,0))
atau menjadi :
=VLookUp( LEFT(A4,2) , 'code customer'!$A$2:$B$52 , 2 , 0 )
Wassalam,
Kid.
2012/12/14 Arif Aji <[email protected]>
> **
>
>
>
> Dear Suhu XL-Mania,
>
> Saya menggunakan rumus
>
> =INDEX('code customer'!$A$2:$A$52,MATCH(LEFT(A4,2),'code
> customer'!$B$2:$B$52,0))
>
> pada sheet2,jadi saya berharap ketika saya update data disheet2 colom
>
> JOB NO 04-B/13/k1212/230/1-1 maka otomatis dikolom CUST harus muncul
>
> EPSONBTM, namun saat saya coba untuk buat di sheet2 kolom CUSTM untuk
>
> code 05/01/k1112/629/1-1 harusnya muncul KYOSHA tapi hanya NA,
>
> mohon penjelasannya dan pencerahaanya
>
> Terima kasih
>
> Arif Aji
>
> Contoh data
> sheet1
>
> KODE INITIAL
> 01 LG TV
> 02 LG EDI (MONITOR)
> 03 LG EDI (VCR)
> 04 EPSON
> 04-B EPSONBTM
> 05 KYOSHA
> 06 HCPI
> 07 HONORIS
> 08 JVC
> 09 KATOLEC
> 10 SBE2
>
> sheet2
>
> JOB NO CUSTM
> 05/01/k1112/629/1-1 #N/A
> 05/01/k1112/631/1-1 kyosha
> 05/02/k1112/633/1-1 kyosha
> 14/09/k1112/636/1-1 PMI
> 25/21/k1112/651/1-2 sanken
> 25/21/k1112/652/1-1 sanken
> 13/21/k1112/654/1-1 nkjima
> 20/14/k1112/644/1-4 smt
> 05/23/k1112/664/1-1 kyosha
> 05/23/K1112/665/1-1 kyosha
> 05/23/k1112/666/1-1 kyosha
> 05/23/K1112/667/1-1 kyosha
> 05/28/K1112/668/1-1 kyosha
> 05/28/K1112/669/1-1 kyosha
> 05/30/k1112/671/1-1 kyosha
> 04/23/k1112/659/1-5 epson
> 05/28/k1112/670/1-1 kyosha
>
>
>
