Retrieving data from a table  
Author Message
paed





PostPosted: Sat Sep 01 10:16:01 PDT 2007 Top

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

Excel473  
 
 
GarysStudent





PostPosted: Sat Sep 01 10:16:01 PDT 2007 Top

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




> 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
 
 
HelpFrom





PostPosted: Sat Sep 01 10:26:02 PDT 2007 Top

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.



> 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
 
 
JB





PostPosted: Sat Sep 01 14:17:49 PDT 2007 Top

Excel Misc >> Retrieving data from a table Hello,

=INDEX(Price,Match(B1,Height,1),Match(B2,Width,1))

http://boisgontierjacques.free.fr/pages_site/fonctionindex.htm#IndexPrix
http://boisgontierjacques.free.fr/fichiers/Tableur/IndexEquivPrix1.xls

JB
http://boisgontierjacques.free.fr/



> 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


 
 
JohninPA





PostPosted: Sat Sep 01 14:18:03 PDT 2007 Top

Excel Misc >> Retrieving data from a table Thank you very much!

John
--
John in PA




> This is a 2-D lookup. See:
>
> http://www.cpearson.com/excel/lookups.htm#DoubleLookup
> --
> Gary''s Student - gsnu200741
>
>

>
> > 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