Jill.Pleau
New Member
I have the need to lookup a "type" in Column A in a small table, as well as lookup an "amount" in Row 1 of the same small table. I've found a very nice formula, but it doesn't work the results are #N/A. Any advice would be greatly appreciated. If I remove the exact match option data is returned, but not accurately.
=INDEX(N30:T36,MATCH(D8,N30:N36,0),MATCH(K16,O30:T30,0))
N30:T36 = Table
D8 = Type
N30:N36 = Type Column
K16 = Amount
O30:T30 = Amount Row
=INDEX(N30:T36,MATCH(D8,N30:N36,0),MATCH(K16,O30:T30,0))
N30:T36 = Table
D8 = Type
N30:N36 = Type Column
K16 = Amount
O30:T30 = Amount Row