If with multiple criteria along with VLookup

I am looking to use an "If" statement with multiple criteria combined with a VLookup. Within the formula below, I want the result to be blank if the Vlookup result is any of the terms I have specified, if it does not match, I want the Vlookup result to stand.

=IF(OR(VLOOKUP([Row ID]26, {Bookkeeper List}, 2, false) = "Onboarding Pool", VLOOKUP([Row ID]26, {Bookkeeper List}, 2, false) = "Onboarding Phase", VLOOKUP([Row ID]26, {Bookkeeper List}, 2, false = "Cancelled"), "",VLOOKUP([Row ID]26, {Bookkeeper List}, 2, false ))

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!