mardi 11 octobre 2016

IF, And, Vlookup in 1 Formula

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