[mso] Excel Lookup Function
- From: Adam Peszel <aepeszel@xxxxxxxxx>
- To: mso@xxxxxxxxxxxxx
- Date: Fri, 16 Jan 2009 17:20:37 -0800 (PST)
Hello,
I am trying to run a lookup in Excel but do not know if this can be done.
I have a populated table that cannot/should not be modified with a side header
of values,
and a top header with values. I need to find a row for a variable using the
side header. Once
there, I need to find a cell with a value equal to or next value greater than
the a constant. I
then need to return the value in the column header that corresponds. Can this
be done?
One of my brothers said it is a reverse lookup and the only way he knows this
can be done
is with Access. If this is the case, can I use OpenOffice Base to program at
home and
open it on Access at work? I know this is not a MS product, but I do not have
Access in my version of Office. Plus, I have no clue how to use either.
Thank you in advance.
Adam
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, visit the group's homepage and use the dropdown
menu at the top. This will allow you to unsubscribe your email address or
change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to share files with the group, you must join our Yahoo sister group.
This group will not allow for posting of emails, but will allow you to join
and share problem files, templates, etc.:
http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for FILE
SHARING ONLY.
If you are using Outlook and you see a lot of unnecessary code in your email
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************
Other related posts:
