Index (Match?) Function

Hi all,

I have been reading a lot of discussions on the index/match function, and cannot for the life of me figure out how to accomplish what I'm trying to do.

I am making a new spreadsheet where I want to pull data from two different sheets. The data from the second sheet will be dependent on the data from the first sheet.

Unfortunately I'm stuck at step 1. I am able to index the names I want, but not have it automatically match the row number. The formula I have gotten to work is:

=INDEX({AST Last Name}, 2)

Where {AST Last Name} references the column in the sheet I am pulling from, but I have to manually change the number at the end (2) for each cell. I have tried variations of @row with no luck.

Can you help?


  • Jake Gustafson
    Jake Gustafson ✭✭✭✭✭✭

    The way I think about INDEX/MATCH is as follows:

    =INDEX(<what value I want to show up in my column>, MATCH(<the value I want to look up>, <the range I'm looking up that previous value in>, 0))

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!