Index-Match multiple sheets

Reagan ✭✭
edited 06/20/22 in Formulas and Functions

Hi! I am a newbie to Smartsheet and jumping in head first.

I am trying to use Index-Match to bring in information to a master sheet, but I need the function to look at multiple reference sheets.

Master Sheet

Highlighted in pink are the columns I am referring to. I would like the User to manually input a number into the 'ASN' column and the 'Network Name' auto-populates

Reference Sheet

I created three reference sheets named by region (AMER, APAC, EMEA) with two columns. The reference sheets have to be separate due to number of rows.

**I tried a simple Index-Match on one reference sheet, and it didn't work. And combining what doesn't work into an IF statement, well seems a bit mad. Below you will find my function statement. I feel like its not total circle, like I am missing the piece that brings the information back to the Master.

=INDEX({AMER ASN Filtered range 3}, MATCH([ASN \[MANUAL INPUT\]]@row,}, {AMER ASN Filtered Range 1}), 1))

Any help would be greatly appreciated.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!