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