Hi,
So this is a bit tricky to explain but I've attached a sample spreadsheet with data, the errant result I'm getting, the desired result, and then additional calculations I plan to do on the data once I get the desired result.
Effectively, the Match function I'm using appears to search right to left as opposed to left to right, so it returns bad data. I've tried hlookups, indexes, offsets, etc, and racked my brain to find other solutions but I can't seem to get there.
If anyone can resolve the match issue or figure out another way to get to my desired result, I will be thoroughly impressed, forever in your debt, and I will sing your praises through all the land.
Thanks,
Kevin
Bookmarks