hI,

I have assumed the top left cell of your table is A1 and extends to J5

=INDEX(A1:J5, MATCH(K1,A1:A5,0), MATCH(L1,A1:J1,0))

Where

K1 is the value to lookup in column A
L1 is the value to look up in Row 1

--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"excelrookie" wrote:

Looking for the correct Function

I have a table that looks sort of like this

A B C D E F G H I J

A 14 14 11 10 9 8 7 6 5 4
B 2 14 14 11 10 9 8 7 6 5
C 3 2 14 14 11 10 9 8 7 6
D
E Etc Etc Etc

I want to right a formula that will return the correct value in the table.
So if I enter A A then 14 if it is B A then 14 but if A B then 2. Any
idea's where I can start?