If with multiple criteria along with VLookup

Ross Novotny

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

Paul Newcome

The parenthesis should be immediately after false just like how you have your other VLOOKUP's.

Paul Newcome

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.

Ross Novotny

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

Paul Newcome

The parenthesis should be immediately after false just like how you have your other VLOOKUP's.

Ross Novotny

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

Paul Newcome

Happy to help. 👍️