Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|