Index match two date ranges

xor · #1 11-02-2016, 12:50 PM

I don't have more energy today.

Will take a fresh look at it tomorrow, but I will not promise I can come up with something useful.

toddkad · #2 11-02-2016, 05:23 PM

Thanks. I don't think I've ever been this stumped by anything in Excel. No matter how I approach this, I continue to get inconsistent results. Appreciate your support.

xor · #3 11-03-2016, 03:10 AM

I have tried again, column E and F in sheet Activity and have made some defined names, see Name Manager. The formula in column F is not mine but is due to a person named Amit Tandon.

Not sure if this gives you what you need, but you may want to take a look at it.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel - Index and Match Function ,First Second and Third Match	paulzy95	Excel	10	09-29-2016 10:46 PM
Translate INDEX(MATCH) into VBA	grexcelman	Excel Programming	1	03-08-2015 05:06 PM
Index match vba	grexcelman	Excel	0	03-05-2015 10:55 PM
Index Match syntax	grexcelman	Excel Programming	0	03-05-2015 07:17 AM
UDF multiple IFs INDEX-MATCH	grexcelman	Excel Programming	0	02-22-2015 04:20 PM