Welcome!

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.

Thanks

Find more posts tagged with

Formulas

Comments

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

?!?

Sign in to join the conversation!

Quick Links

Trending discussions

Automation Change Cell Value not working, but working when Test run
I have a Checkbox (Flag) which should change the Value in a Drop Down List to specific Value, which is with formula then referring to shorter Offset days according to a supporting sheet. When I do a Test run of the Automation it works, but when I manually check the Box, its not changing the Cell Value. INDEX(COLLECT…
Formula to Display Weekday Horizontally
Hi, I have a sheet where i am trying to pull the weekday horizontally based on the dates.But I am unable to fix the formula.Can anyone suggest what formula to use
Need Help With Date Calculation Formula
Hello, I have 2 date columns. I put a test sheet together for a visual reference. The Date 2 column needs a formula to calculate whichever date 39-45 days out is a Friday. Any help would be greatly appreciated.