Configuring proper syntax for multiple-worksheet and criteria using INDEX-MATCH, and others

Excel-User · #3 12-05-2016, 07:22 PM

Thanks Xor,

I'd like to incorporate that if I can. I was puttering around a little more with what I started and think I established a very basic version attached.

In the first worksheet labeled Track I would need to somehow make a dynamic range so that when I add new updated rows the table will expand and formulas in col F would follow suit to match corresponding cell values and data range. Hope this makes sense.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
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
Entering proper syntax to SKIP unwanted Records	jp91306	Mail Merge	1	04-14-2014 03:15 PM
Help with multiple match and index formula	ryanwood	Excel	1	09-12-2012 07:53 AM
Vlookup or Index/Match - Multiple Criteria	ruci1225	Excel	1	01-15-2012 07:31 AM