Yes, this is my world now, but in an effort to help others not waste time like I did…
If you are creating an INDEX MATCH formula in excel to do a multi-conditional VLOOKUP, Do NOT use tables or table columns. If you do use them you will #N/A results. For whatever reason it only works with non-table arrays.
And there goes 2 hours of my life I will never get back.
Well, I was running Index(Match) for awhile, but my-oh-my is it a painful query. Instead, for what I was doing, it’s just easier and faster to concatenate and vlookup.