Multiple IF statements HELP!

Ashley Styers

The request is to check L2 and if it is NAME1 OR NAME2, then look at L3 to return the contact.

Trying to return a contact but need to look at two IF's to make it happen:

I currently have:

=IF([L2]@row = "NAME1", VLOOKUP([L3]@row, {POC}, 2, false), VLOOKUP([L2]@row, {POC}, 2, false))

and I need to add

IF([L2]@row = "Name2", VLOOKUP([L3]@row, {POC}, 2, false), VLOOKUP([L2]@row, {POC}, 2, false))

{POC} is a referenced sheet returning column 2, and the L2

But when I try to AND to join them, it comes back unparsable. HELP!

What the heck am I missing to make this work? :)

Kelly Moore

Hello @Ashley Styers

I assumed your VLookUps were working (?) so I left that alone.

You want to use an IF(OR)

=IF(OR([L2]@row="NAME1", [L2]@row="Name2"),VLOOKUP([L3]@row, {POC}, 2, false), VLOOKUP([L2]@row, {POC}, 2, false))

https://help.smartsheet.com/function/or

cheers

Ashley Styers

That isn't working - I wonder if my VLOOKUP isn't correct?