View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
JB JB is offline
external usenet poster
 
Posts: 115
Default 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