If Statement with nested VLOOKUP formula

Hi! I would like to return a value from another SmartSheet if one column in that same SmartSheet has a "Y". I have the current formula below, but it's returning a #NO MATCH error... any thoughts?

In summary: return value in column A of SmartSheet Y to SmartSheet X if coulumb B in SmartSheet Y = Yes.

=IF(VLOOKUP(Customer@row, {A3DPV Master Printing Status Range 4}, 5, false) = "Y", VLOOKUP(Customer@row, {A3DPV Master Printing Status Range 4}, 2, false), false)

Thank you!

Thu

Find more posts tagged with

Formulas

Accepted answers

GrahamWelsby

Hi Thu,

The column count, is this correct and looking in the correct column numbers.

You've typed false for the false statement, try putting that in double quotes - "False"

Thanks Graham

GrahamWelsby

Hi @Thu Nghiem, daft question, but I'd need to ask, the range you've set up, I assume does include the columns you need, and are there some "Y"s in the column your looking for?

Do you have multiple references of the same customer?

All comments

GrahamWelsby

Hi Thu,

The column count, is this correct and looking in the correct column numbers.

You've typed false for the false statement, try putting that in double quotes - "False"

Thanks Graham

Thu Nghiem

Hi @graham18628!

Yes, I believe the column counts are correct. I did go ahead and put False in quotations, but it still gave me the #NO MATCH error.

Revised formula: =IF(VLOOKUP(Customer@row, {A3DPV Master Printing Status Range 4}, 5, false) = "Y", VLOOKUP(Customer@row, {A3DPV Master Printing Status Range 4}, 2, false), "false")

Thank you!

Thu

GrahamWelsby

Hi @Thu Nghiem, daft question, but I'd need to ask, the range you've set up, I assume does include the columns you need, and are there some "Y"s in the column your looking for?

Do you have multiple references of the same customer?

Thu Nghiem

Morning, @graham18628!

I came back to it today and the formula seems to be working! YAY! Thank you for all of your help. I didn't alter anything from the formula I C&P'ed above, I guess SmartSheets just needed some time to refresh.

Thank you again for all of your help and happy holidays!!

Thu

GrahamWelsby

@Thu Nghiem no a problem. Glad it's working for you.

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.