Rumus :
KODE = B
MERK = C
CABANG = D
=INDEX(B2:B10,MATCH(1,(C2:C10="YAMAHA")*(D2:D10="MEDAN"),0))
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))
Subscribe to:
Posts (Atom)