Referencing to Smartsheet table (consisting of 30+ columns) in INDEX/MATCH formula but shows error

neetuchopra05

Hey,

I am using the below formula→

=INDEX({Source_Sheet_Entire_Table}, MATCH([Unique ID]@row , {Source_Sheet_ID_Column}, 0), 1)

Although the answer should be "Project details" mentioned in Column 1, it says #No Match.

What am I doing wrong?

Find more posts tagged with

Sheets

Accepted answers

All comments

ker9

@neetuchopra05

I don't think the ",1" at the end is needed:

=INDEX({Source_Sheet_Entire_Table}, MATCH([Unique ID]@row , {Source_Sheet_ID_Column}, 0))

Paul Newcome

How are the unique ids populated on each of the sheets?

neetuchopra05

Hey, Thank you @ker9 and @Paul Newcome , the issue got sorted now. I was bringing in 2 sheet tables by using Index twice. But in second referencing the sheet name was incorrect. As soon as I resolved the name, it started working…

Cheers,

Neetu Chopra

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.