F
Frank Kabel
Hi
try something like
=INDEX(A1:G20,MATCH(row_search_value,A1:A20,0),MATCH
(col_search_value,A1:G1,0))
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.
try something like
=INDEX(A1:G20,MATCH(row_search_value,A1:A20,0),MATCH
(col_search_value,A1:G1,0))
a horizontal row of numbers and a vertical column of-----Original Message-----
In need to come up with a formula that allows me to have
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.