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  

Paul Newcome

Could you post some screenshots so we can see what exactly you are working with?

shornbuckle

Awesome! That totally worked! 

Thanks everyone for all your help.

Paul Newcome

?!?