Search results

Glad to be able to help.. If the table is massive, I'm told you may want to use INDEX rather than VLOOKUP.

=VLOOKUP(A8,$A$2:$D$4,(IF(A6=B1,2,IF(B8=C1,3,4)))) This should work in the example given. I take it your real life example has many more columns than 3? If so you could add the numbers 1 - N underneath your table and use HLOOKUP to call back the column indicator for the Vlookup Like so CLUB...