I have a table of values that looks like this:
aaa 2017 22.1 2028 36.2
zzz 2026 10.0 2032 24.0
kkk 2013 14.1 2015 13.5
The table is not sorted in any way.
I would like to search down the 1st column to find a value matching the contents of another cell, say A1, then move along that row to find the column matching the contents of another cell, say A2.
Let's say A1 = kkk, A2 = 2015. Then I want to get the value for the cell to the right, in this case = 13.5. I have tried all kinds of functions, like lookup, Index, Match etc with no luck. I can find the correct row, but I don't know how to look in that row to find the right column. Can anyone help? Thanks.
Bookmarks