I need to evaluate a least 3 logical tests in several areas of my spread sheet. I have successfully used the If statement, but want to "simplify" and use vlookup. Below is and example evaluating two tests.
=IF(OR(D2="x", D2="y", D2= "z"),VLOOKUP(H2,Sheet2!$F$2:$G$3,2,TRUE),
VLOOKUP(H2,Sheet2!$F$4:$G$13,2,TRUE))