Wa'alaykum salam warohmatullohi wabarokatuhu..
Pak Mulki;
Coba begini:
=INDEX('LIST
MASTER'!C$3:C$10,MATCH(LEFT($H3,IFERROR(FIND(".",$H3,1)-1,FIND("N",$H3,1)-1)),'LIST
MASTER'!$B$3:$B$10,0))
Copas kekanan dan kebawah
Wassalam
~ Bagus ~
----- Original Message -----
From: 'Mulki Akbar' [email protected] [belajar-excel]
To: [email protected]
Sent: Friday, July 18, 2014 11:50 AM
Subject: [belajar-excel] Membaca data [1 Attachment]
Assalamu'alaikum Wr. Wb.
Mohon bantuan para guru & rekan2 B-XL-ers ttg kasus membaca data PART NO. yg
berbeda jumlah pengambilan karakter yg ingin dibaca.
Terimakasih atas bantuan dan pencerahannya.
Wassalam,
Mulki
