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

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! 😀

Find more posts tagged with

Accepted answers

All comments

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

Mark

Comes up as #UNPARSEABLE..

Pls try it yourself, and let me know.

Thank you!

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!

@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.

@Mark Cronk @Paul Newcome

Any other suggestions?

those didn’t work.

try it on your own sheet before.

Thanks! 😉😊

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

Thank you,

Mark

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.