close

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: www.excelforum.com/member.php...oamp;userid=34509
View this thread: www.excelforum.com/showthread...hreadid=542751www.contextures.com/xlFunctio...ml#IndexMatch2

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
quot;It is a good thing to follow the first law of holes;
if you are in one stop digging.quot; Lord Healeyquot;JariHquot; gt; wrote in
message ...
gt;
gt; Please excuse the ignorance, I would search if I knew how to word what I
gt; am trying to do. I have a grid of numbers and I want to enter 2 numbers
gt; and have excel find where they intersect and give me the value in that
gt; cell. As well the numbers along the top and side are 57-60 or 72-78
gt; along those lines so I would need excel to know that if I tye 58 it
gt; would go to column A or whatever column coincided with that value, and
gt; the same along the side.
gt; I am not even sure if what I am saying is clear, its clear in my head..
gt; Please if anyone can help me. I am pretty sure its not a difficult thing
gt; I just cant figure it out.
gt;
gt; Thanks!
gt; Jari
gt;
gt;
gt; --
gt; JariH
gt; ------------------------------------------------------------------------
gt; JariH's Profile:
gt; www.excelforum.com/member.php...oamp;userid=34509
gt; View this thread: www.excelforum.com/showthread...hreadid=542751
gt;

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

Jari--
JariH
------------------------------------------------------------------------
JariH's Profile: www.excelforum.com/member.php...oamp;userid=34509
View this thread: www.excelforum.com/showthread...hreadid=542751

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()