return value from table

M

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
 
D

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Returning value based on input data 2
LOOKUP value in a table and return value in first column of same r 2
Find values in table and return row/column name 7
Return value from a Two Variable Data Table with Dates 1
Find Duplicate Values and Return Another Value 1
Compare value to Lookup table min & max, return contents of 3rd ce 8
Select cell containing specific text &return value from another ce 4
Function evaluate multiple cells and return 1st one w/a value 1

Top