return value from table
 

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

return value from table
 

=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.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"MS_user" wrote in message
...
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

return value from table
 

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


"Don Guillett" wrote:

=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.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"MS_user" wrote in message
...
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