Index Match with 2 sheets

shornbuckle · 07/09/18

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 · 07/09/18

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

shornbuckle · 09/11/18

Awesome! That totally worked!

Thanks everyone for all your help.

Paul Newcome · 09/11/18

?!?

Index Match with 2 sheets

Comments

Help Article Resources

Categories