Index Match with 2 sheets

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.




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!