Index Match with 2 sheets

shornbuckle
✭✭
Hi, I have successfully setup an index/match with 1 sheet but I need to add a 2nd sheet for the index to search as well. How would I set this up in the formula? I tried to notate both sheet's columns for the range but keep getting an error.
Thanks
Tags:
Comments
-
Could you post some screenshots so we can see what exactly you are working with?
-
Awesome! That totally worked!
Thanks everyone for all your help.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!