Wednesday, October 21, 2015

LookUp Excel dengan kriteria lebih dari 1





Rumus  :
KODE = B
MERK = C
CABANG = D

=INDEX(B2:B10,MATCH(1,(C2:C10="YAMAHA")*(D2:D10="MEDAN"),0))
Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)