Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Another way, using exactly the same layout that Mickey showed would be to put
this formula into G3 where he put his VLOOKUP() formula: =INDEX(A1:E5,MATCH(G1,A1:A5),MATCH(G2,A1:E1)) "MS_user" wrote: i need to get info from table: Dist / Age 12 13 14 15 100 1.4 2.0 3.0 4.0 200 1.3 2.1 3.1 4.2 300 1.5 2.2 3.2 4.4 400 1.6 2.3 3.4 3.4 So, if i needed to get data for a 14 year old where distance is 300, I need to search both row and column labels to get required row and column numbers in order to retrieve data - in this case 3.2 Any ideas? I can put absolute row and column numbers in, e.g. 3,3 but i need to search labels first based upon contents of another cells (in this case 14 and 300). Assistance greatfully received!!! Many thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to update column info based on column info from another worksh | Excel Discussion (Misc queries) | |||
Lookup info in one Column and then returning info in other columns | Excel Worksheet Functions | |||
Referencing date column A & time column B to get info from column | Excel Discussion (Misc queries) | |||
How do I sort by info in one column and it stay in line with info | Excel Worksheet Functions | |||
Link info in one cell to info in several cells in another column (like a database) | Excel Discussion (Misc queries) |