View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
TomPl TomPl is offline
external usenet poster
 
Posts: 342
Default getting info from array but not using column / row numbers

Assume that your table range is in Cells A1 to E5.
Assume that the age is entered into Cell H2.
Assume that the distance is entered into Cell H3
Use this formula to lookup the number in the table:
=HLOOKUP(H2,A1:E5,MATCH(H3,A1:A5),FALSE)