Hi.
I have a lot of data in a large table which have unique column headers and unique rows.
All I want to be able to do is lookup each number in that table, which is a unique row/column combination.
I've tried sumifs etc., but that gives me value errors.
I assume there would be some simple if/vlookup combination that could give me my desired result.
See attached sheet for example. The highlighted yellow area is where I would like the formula to be.
Any ideas guys?
Thanks in advance for any suggestions.
Bookmarks