[mso] Re: Excel Lookup Function, simplified

From: Wilson Baptista Junior <wilsonbaptista@xxxxxxxxxxxx>
To: mso@xxxxxxxxxxxxx
Date: Sun, 18 Jan 2009 22:30:11 -0200
Adam,
the formula I gave you assumes that the side header has values in increasing 
order from the top down. As this is not always true, the following formula 
(which is simpler, by the way) will work, as long as the data in the columns 
under the top header is in increasing order from right to left:

=LOOKUP(H2;OFFSET($D$4;MATCH(G2;$C$5:$C$9;0);0):OFFSET($D$4;MATCH(G2;$E$5:$E$9;0)+1;0);$D$4:$G$4)

(We're assuming that your table spans cells C4 to G9, with the side header 
running from cell C5 to cell C9, and the top header running from cell D4 to G4,
and that you have, in cell G2, the value of the variable you're going to search 
for in the side header, and in cell H2 the constant you want to search for).
Best,
Wilson

 Adam Peszel wrote:
>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
*************************************************************

Esta mensagem foi verificada pelo E-mail Protegido Terra.
Atualizado em 17/01/2009


-------------------------------------------------------------- 

*************************************************************
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
*************************************************************

Esta mensagem foi verificada pelo E-mail Protegido Terra.
Atualizado em 17/01/2009


-------------------------------------------------------------- 

*************************************************************
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
*************************************************************
[mso] Re: Excel Lookup Function, simplified

Other related posts:
