Index and match multiple sheets

shornbuckle
shornbuckle ✭✭
edited 12/09/19 in Formulas and Functions

Hi, I have an index and match formula set up for 1 sheet and it works great but how do I handle it if I want the index to look at data from multiple sheets to pull the correct information. My current formula is:

=INDEX({Site Number}, MATCH([Site ID]62, {Site Name}, 0))

I would like the index to look at the site number on about 3 or more different sheets. Can this be done?

 

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!