If Column 1 contains "Yes", Vlookup data from Column 2.

A Rose

Hi Community,

I want to lookup data, based on data on my current sheet,

If Column 1 contains "Yes", Vlookup data from Column 2.

IF Column 1 CONTAINS "YES" VLOOKUP Other Sheet Reference,2,false

Any way to do that?

Thank you in advance! 😀

Mark Cronk

=IF( CONTAINS("Yes", [Column 1]@row)="True", VLOOKUP (Other Sheet Reference,2,false),"")

Mark

A Rose

@Mark Cronk

Comes up as #UNPARSEABLE..

Pls try it yourself, and let me know.

Thank you!

A Rose

@Mark Cronk

i corected it, to match exactly, now Comes up as #NO MATCH..

Pls try it yourself, and let me know.

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

Thank you!

Paul Newcome

@Mark Cronk Just a quick note... CONTAINS functions don't necessarily need = "True". You can just use

=IF(CONTAINS("Yes", [Column 1]@row), output)

@A Rose For the error, that means it is not finding whatever is in [Column 2]@row in the 1st column of the range.

A Rose

@Mark Cronk @Paul Newcome

Any other suggestions?

those didn’t work.

try it on your own sheet before.

Thanks! 😉😊

Mark Cronk

Hi @A Rose ,

Can you upload screenshots of your sheets and formulas so we can help find the error?

Thank you,

Mark

Paul Newcome

@A Rose Make sure that whatever is in [Column 2]@row is in the far left column of {Sheet 1 Range 1}.