What is wrong with my code?
I have 2 criterias that I need matched and If " True than vlook up the company unit #. =IF(AND(B20=Sheet1!$B$3:$B$2718,Sheet1!$K3:$K2718="C"),VLOOKUP(B20,Sheet1!$B$3:$D$2718,3,0))
Aucun commentaire:
Enregistrer un commentaire