Index Match Function

Anne Rudwick

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))

Neil Egsgard

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