Excel Table lookup with indexes in multiple columns
- by Matthew Scouten
I have a Table in Excel the looks about like this:
Test1 100 test2 200
Test3 110 test4 210
Test5 120 test6 220
I want a function that, given test 1 as input, will return 100 AND given test 2 will return 200
LOOKUP, (V/H)LOOKUP, and INDEX all insist on a single contiguous array for the index column.