# 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 ))

• It looks like you didn't close out your 3rd VLOOKUP after false, so it automatically put an extra closing parenthesis on the end of the formula. Try moving that to close out the 3rd one and you should be good to go.

• Hey Paul, I adjust the formula, but I am getting an "Invalid Data Type" error. This is the formula as it looks now with your recommended update:

=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))

• Oh great catch. I was staring at this too long. That worked, thank you.

• Happy to help. 👍️

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!