Thread: Retrieving data from a table
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default 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
Reply With QuoteReply With Quote