Returning values in a table

[Mick]

I have a table with headings down the left hand side and along the top. I
would like to get a value from the table based on these headings.

A B C
One 1 2 3
Two 4 5 6
Three 7 8 9

If my first cell has One and my second cell has C I want the value 3
returned.

Any easy answers to this one?

Thanks,
Mick.

 

[Mick]

Don't worry, solved it!!!

Thanks all,
Mick.

 

[Domenic]

Hi Mick,

Try,

=INDEX(B24,MATCH("One",A2:A4,0),MATCH("C",B11,0))

Hope this helps!