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
- Mar 09 Fri 2007 20:36
Not sure how to ask
close
全站熱搜
留言列表
發表留言