return value from table

[MS_user]

confused about which is the best method / function of returning data from a
table!! Table as follows:
Age 12 13 14 15
Event
A 1.12 1.10 1.05 1.00
B 6.20 4.45 2.34 1.89
C 3.99 3.50 3.23 2.33

So thats the type of table! Elsewhere in the spreadsheet I would like to
look data from the above table based upon values in cells. For example an
entry maybe Age of 14 and Event B. In which case the function should return
2.34. Values for look up maynot be absolute and will depend on what cell
value is, there I may wish to use cell referenece G9 (which contains value
14) and H12 (which contains value B) - still returning a value of 2.34

I hope someone can help in my quest / understanding.

Many thanks

 

[Don Guillett]

=INDEX(A1:E5,MATCH(H12,A:A),MATCH(G9,1:1))
=VLOOKUP(H12,A1:E5,MATCH(G9,1:1))
=HLOOKUP(G9,A1:E5,MATCH(H12,A:A))

Any of these should do it.

 

[MS_user]

Many thanks for your quick response. I will try them - help much appreciated.