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))
What's the third option?
Please consider:
Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.
I guess it would look like this
=IF(OR(OR(D2="x", D2="y", D2= "z"),VLOOKUP(H2,Sheet2!$F$2:$G$3,2,TRUE),
(D2="a", D2="b"),VLOOKUP(H2,Sheet2!$F$4:$G$13,2,TRUE), VLOOKUP(D2,Sheet2!$F$14:$G$16,2,TRUE)
I think this is what you are after:
Formula:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks