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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top