Not sure how to ask
 

Please excuse the ignorance, I would search if I knew how to word what I
am trying to do. I have a grid of numbers and I want to enter 2 numbers
and have excel find where they intersect and give me the value in that
cell. As well the numbers along the top and side are 57-60 or 72-78
along those lines so I would need excel to know that if I tye 58 it
would go to column A or whatever column coincided with that value, and
the same along the side.
I am not even sure if what I am saying is clear, its clear in my head..
Please if anyone can help me. I am pretty sure its not a difficult thing
I just cant figure it out.

Thanks!
Jari


--
JariH
------------------------------------------------------------------------
JariH's Profile: http://www.excelforum.com/member.php...o&userid=34509
View this thread: http://www.excelforum.com/showthread...hreadid=542751

Not sure how to ask
 

http://www.contextures.com/xlFunctio...ml#IndexMatch2

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"JariH" wrote in
message ...

Please excuse the ignorance, I would search if I knew how to word what I
am trying to do. I have a grid of numbers and I want to enter 2 numbers
and have excel find where they intersect and give me the value in that
cell. As well the numbers along the top and side are 57-60 or 72-78
along those lines so I would need excel to know that if I tye 58 it
would go to column A or whatever column coincided with that value, and
the same along the side.
I am not even sure if what I am saying is clear, its clear in my head..
Please if anyone can help me. I am pretty sure its not a difficult thing
I just cant figure it out.

Thanks!
Jari


--
JariH
------------------------------------------------------------------------
JariH's Profile:
http://www.excelforum.com/member.php...o&userid=34509
View this thread: http://www.excelforum.com/showthread...hreadid=542751

Not sure how to ask
 

Yes!
That is exactly what I wanted to say. Thank you so much :)

Jari


--
JariH
------------------------------------------------------------------------
JariH's Profile: http://www.excelforum.com/member.php...o&userid=34509
View this thread: http://www.excelforum.com/showthread...hreadid=542751