[mso] Re: VLOOKUP Question - want exact match only! Thanks Again!!
- From: "Linda F. Johnson" <linda@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
- To: mso@xxxxxxxxxxxxx
- Date: Sun, 19 Jan 2003 17:01:35 -0500
Just add the word FALSE to get an exact match. By default, Excel assumes if
you don't put this in, that you want an approximate match (which is the same
as using the word TRUE)
So...your formula should look like this:
=VLOOKUP(B2,$N$2:$O$40,2,FALSE)
If you want to know more about vlookups, I have an interactive vlookup
formula at my website here:
http://personal-computer-tutor.com/vlookup.htm
Hope this helps.
Linda
Publisher ~ ABC ~ All 'Bout Computers
Owner ~ Linda's Computer Stop
http://personal-computer-tutor.com
FREE MS Office eBook Tutorial
http://personal-computer-tutor.com/library.htm
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf
Of Donald C. Smith
Sent: Sunday, January 19, 2003 2:06 PM
To: Mso-Microsoft Office Newsgroup (E-mail)
Subject: [mso] VLOOKUP Question - want exact match only! Thanks Again!!
I have a VLOOKUP formula that probably works as it is supposed to, but it
returns the closest value. I don't want it to return any value unless the
match is exact.
I would once again appreciate help.
Thanks
Don
=VLOOKUP(B2,$N$2:$O$40,2)
*************************************************************
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:
