looking up data

F

Frank Kabel

Hi
try something like
=INDEX(A1:G20,MATCH(row_search_value,A1:A20,0),MATCH
(col_search_value,A1:G1,0))
-----Original Message-----
In need to come up with a formula that allows me to have
Click to expand...
a horizontal row of numbers and a vertical column of
numbers and when you select a number on the horizontal row
and one on the vertical column where the two rows cross it
returns the data in that cell. can anyone help me.
 
Top