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)


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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!