[mso] Re: Fwd: RE: Re: LOOKUP function in Excel
- From: "Andrew Kendon" <tyto2820@xxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Mon, 16 May 2005 18:35:34 +0100
In case it helps your researches, I also added a spoof 4th column with a
value which wouldn't show in MIN ... Same result. If the minimum value is
not in columns 1 or 2 (regardless of the order) then LOOKUP doesn't appear
to work. Incidentally, that was in Office 2000. Now I'm home, I'm going to
try it in 2003.
For problems like this, Ray Blake is usually your man: I hope he has some
input :)
You deserve a break, lol!
Andrew K
> -----Original Message-----
> From: mso-bounce@xxxxxxxxxxxxx
> [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf Of
> agjones.bpd@xxxxxxxxxxxx
> Sent: 16 May 2005 17:57
> To: mso@xxxxxxxxxxxxx
> Subject: [mso] Fwd: RE: Re: LOOKUP function in Excel
>
> Hi Andrew, and thanks for the effort! I was worried that the
> garbled Copy/Paste would mean no-one would understand .....
> but you have! What you say is precisely IT!
>
> The first thing I came up with was the fact that the VECTOR
> (i.e. the LOOKUP "source"
> range of cells) apparently has to be sorted in Ascending
> order, but it isn't in the first SS so why does that work?!!!
>
> Next, #NA Help, in its only reference to LOOKUP, says "If
> lookup_value is smaller than the smallest value in
> lookup_vector, LOOKUP gives the #N/A error value" ..... but
> it isn't smaller, and the value is actually referenced FROM
> the vector!
>
> I also discovered, as you say, "it just doesn't work for the
> final column in the range" but what is more, LOOKUP continues
> to give #NA 3 if you repeatedly increase the column 3 value
> by 1 ..... UNTIL that equals and then passes the column 2 value!
>
> Oddly enough, if you juggle the 3 single cell values, i.e.
> putting the one MIN finds in one of the other columns, then
> LOOKUP works but I can't rearrange the values on every line
> just to suit the whims of LOOKUP!!!!!
>
> I need a break!
>
*************************************************************
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, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in
the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
