Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Which formula will return a value for this table? | Excel Discussion (Misc queries) | |||
Return values from table | Excel Worksheet Functions | |||
how do I return a value between two other values from a table | Excel Worksheet Functions | |||
Pivot Table: Return Value From Same Row | Excel Discussion (Misc queries) | |||
need look up table to return blank | Excel Worksheet Functions |