Index Match Function

Hello,

I am trying to mimic an Index (Match) formula in smartsheet.

When a drop down is selected, on grid 1, a different column will autopopulate with a related data. This is the formula in Excel. I don't know how to create this in smartsheet.

Sheet 1 - is grid I am referencing and it is feeding into Sheet 2 (activity)

Example - Index Match.xlsx

=INDEX(Sheet1!B$1:$B$16,MATCH(C2,Sheet1!$A$2:$A$16,0))

Find more posts tagged with

Accepted answers

All comments

Hi @Anne Rudwick ,

It functions very similarly to Excel. You need to use cross sheet references instead of "Sheet1!...".

It looks like

=INDEX({Cross sheet reference to source range}, MATCH(Cell to Match,{Cross sheet reference to matching range},0))

Take a look at this video for more details on cross sheet references.

Neil

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.