Pake Index dan Match: untuk di sel D3:
=INDEX($B$12:$B$16,MATCH(C3,$C$12:$C$16,0))



________________________________
From: Niki Dwinarni <[email protected]>
To: Group Excell <[email protected]>
Sent: Tuesday, May 10, 2011 3:25 PM
Subject: [belajar-excel] Kode


  
Temen2 B-excel...tlg bantuannya ya...utk lbh jelas casenya ada di attach file

trims




 
 

Kirim email ke