| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Retrieving data from a table
I have data in a table and would like to retrieve it from a column figure
derived from one cell and a row figure from a second cell. Basically, enter the table with a column request from one cell and a row request from another cell and display the intersecting value in the table in a third cell. Hope this makes sense. John in PA |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Retrieving data from a table
This is a 2-D lookup. See:
http://www.cpearson.com/excel/lookups.htm#DoubleLookup -- Gary''s Student - gsnu200741 "John in PA" wrote: I have data in a table and would like to retrieve it from a column figure derived from one cell and a row figure from a second cell. Basically, enter the table with a column request from one cell and a row request from another cell and display the intersecting value in the table in a third cell. Hope this makes sense. John in PA |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Retrieving data from a table
Gary has provided a way if the values (row/column requests) are 'random'
values, but if they are actual row and column number references then you can either use INDEX or OFFSET. Assume your array of data to look into is in B3:F12 your row # is in F16, your column number in G16 =INDEX(B3:F12,F16,G16) or =OFFSET(B3,F12-1,G16-1) both will return the same value from the data array. "John in PA" wrote: I have data in a table and would like to retrieve it from a column figure derived from one cell and a row figure from a second cell. Basically, enter the table with a column request from one cell and a row request from another cell and display the intersecting value in the table in a third cell. Hope this makes sense. John in PA |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Retrieving data from a table
Hello,
=INDEX(Price,Match(B1,Height,1),Match(B2,Width,1)) http://boisgontierjacques.free.fr/pa....htm#IndexPrix http://boisgontierjacques.free.fr/fi...EquivPrix1.xls JB http://boisgontierjacques.free.fr/ On 1 sep, 19:06, John in PA <John in wrote: I have data in a table and would like to retrieve it from a column figure derived from one cell and a row figure from a second cell. Basically, enter the table with a column request from one cell and a row request from another cell and display the intersecting value in the table in a third cell. Hope this makes sense. John in PA |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Retrieving data from a table
Thank you very much!
John -- John in PA "Gary''s Student" wrote: This is a 2-D lookup. See: http://www.cpearson.com/excel/lookups.htm#DoubleLookup -- Gary''s Student - gsnu200741 "John in PA" wrote: I have data in a table and would like to retrieve it from a column figure derived from one cell and a row figure from a second cell. Basically, enter the table with a column request from one cell and a row request from another cell and display the intersecting value in the table in a third cell. Hope this makes sense. John in PA |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| retrieving data | Excel Worksheet Functions | |||
| QUERIES OR RETRIEVING DATA | Excel Discussion (Misc queries) | |||
| Retrieving data from another table or array .. | Excel Worksheet Functions | |||
| Retrieving data from the web - help ! | Excel Worksheet Functions | |||
| Pivot table retrieving data from several worksheets | Excel Worksheet Functions | |||
Linear Mode
