Forum Discussion
IF (AND) FORMULAS WITH MULTIPLE CRITERIAS
I am trying to create an IF statement with multiple criteria. I have created a list of programs, there are 9 (on Sheet1), each has a different cost. I was able to figure out how to populate the ...
In H7:
=VLOOKUP(E2,Sheet1!$A$2:$E$10,2,FALSE)
In H8:
=VLOOKUP(E2,Sheet1!$A$2:$E$10,IF(F3="Other",5,4),FALSE)