IF CONTAINS VLOOKUP

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

Find more posts tagged with

Accepted answers

All comments

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

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.