Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / May 2006

Tip: Looking for answers? Try searching our database.

Not sure how to ask

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
JariH - 17 May 2006 03:13 GMT
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

Signature

JariH

Peo Sjoblom - 17 May 2006 03:27 GMT
http://www.contextures.com/xlFunctions03.html#IndexMatch2

Signature

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

> 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
[quoted text clipped - 9 lines]
> Thanks!
> Jari
JariH - 17 May 2006 03:48 GMT
Yes!
That is exactly what I wanted to say. Thank you so much :)

Jari

Signature

JariH

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.