IF CONTAINS VLOOKUP

A Rose

Hi,

I'm trying to do the below formula, that if Column 1 Contains "No Match", VLOOKUP Column 2, and get Value from referenced sheet, is that possible?

see below.

=IF(CONTAINS("No Match", [Column 1]@row:[Column 1]@row), " ", " ",(VLOOKUP([Column 2]@row, {Sheet Name Range 1}, 2 ,false )

Thank you

Mark Cronk

Hi @A Rose ,

Try:

=IFERROR(VLOOKUP([Column 1]@row, {Sheet Name Range 1}, 2 ,false), VLOOKUP([Column 2]@row, {Sheet Name Range 1}, 2 ,false))

Work?

Mark

A Rose

@Mark Cronk ,

that didn’t either work..

pls let me know if any other suggestions.

Thanks 🙂

Mark Cronk

Hi @A Rose ,

Did it return an error or the wrong answer? Can you upload screenshota of your sheets and formulas? That would help us help you.

Mark