Output data from table

[JamesAppleby]

Hello,

I have a table with A, B, C and D down one side and A, B, C and D across the top, in the middle of that table are values.

I want to get excel to then be able to find the value of any cell, for example A,C or D,B and so on, and provide the value.

Any help would be greatly appreciated.

Thanks,

James

 

[Fluff]

You can do that like

=INDEX(B2:E5,MATCH("C",A2:A5,0),MATCH("B",B1:E1,0))

 

[JamesAppleby]

You can do that like

=INDEX(B2:E5,MATCH("C",A2:A5,0),MATCH("B",B1:E1,0))

That has worked brilliantly Thank you Fluff

 

[Fluff]

You're welcome & thanks for the feedback.