[mso] Re: VLOOKUP Question - want exact match only! Thanks Again!!
- From: "Greg Chapman" <greg@xxxxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Sun, 19 Jan 2003 14:22:20 -0600
Nope, the article I quoted was merely explicit to XP. These values are
also true to earlier versions as explained in 181213 at
http://support.microsoft.com (Microsoft Excel 2000, Microsoft Excel
2002, Microsoft Excel 97 for Windows).
As for the average human, they don't mess with VLOOKUP and I won't
pretend to be capable of improving on the MSKB in most instances. I do
*highly* recommend that you work on becoming comfortable with the KB
through http://support.microsoft.com . You'll discover that most of the
answers are already there and that the trick of the thing is to learn
how to construct a useful query. That's also the part that will have you
screaming at times.
Anyway, if you take a little more time to study, you'll find the answer
is there in the original reply. Besides, part of you being here is to
try and become something more than average (or so I thought). But that's
too philosphical and may simply be a result of me reading too much
Umberto Eco in recent days.
To help, though, here is a quote from 181213 that might be more
readable:
=VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)
where:
Argument Definition of argument
---------------------------------------------------------------------
lookup_value The value to be found in the first column of the array.
table_array The table of information in which data is looked up.
col_index The column number in the table_array for which the
matching value should be returned.
range_lookup It is a logical value that specifies whether
you want to find an exact match or an approximate match.
If TRUE or omitted, an approximate match is returned; in
other words, if an exact match is not found, the next
largest value that is less than the lookup_value is
returned. If FALSE, VLOOKUP finds an exact match. If an
exact match is not found, the #N/A error value is
returned
There are examples on that page as well so I recommend you go look it up
and print it out.
And now I will commit the cardinal sin of giving you the answer directly
<g>:
=VLOOKUP(B2,$N$2:$O$40,2,FALSE)
Remember, "If an exact match is not found, the #N/A error value is
returned."
There, after all that info, I don't know how much worse a teacher I
could possibly be and at the same time hand you what you wanted.<g> Oh,
one last thing; even after you're done with this, I still won't expect
you to track the orbital trajectory of any heavenly bodies so don't
worry about the rocket science.
Greg Chapman
http://www.mousetrax.com
"Counting in binary is as easy as 01, 10, 11!
With thinking this clear, is coding really a good idea?"
> -----Original Message-----
> From: mso-bounce@xxxxxxxxxxxxx
> [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf Of Donald C. Smith
> Sent: Sunday, January 19, 2003 2:00 PM
> To: Mso-Microsoft Office Newsgroup (E-mail)
> Subject: [mso] Re: VLOOKUP Question - want exact match only!
> Thanks Again!!
>
>
> It figures that it would make a difference in this case. I
> have Excel 2000 with Windows 2000. I do have XP also but it
> needs to be compatible with both versions. My lookup is in
> descending order as I used the sort function when I set it
> up. I am assuming from what you said that what you have
> described (keep in mind I am not a rocket scientist) will not
> work in 2000. If it will maybe you can explain it in SIMPLE
> American English. Remember the AVERAGE person can only hold
> an average of seven pieces of information in short term
> memory for only a minute or two. Hopefully the formula I
> have at the bottom of the page will simplify things (for all,
> especially me). Thanks Again Don
>
*************************************************************
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?Subject=unsubscribe
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:
