[mso] Re: Check for existence in column? Excel 2000 [Scanned]

Robert

I think this should do it:

eg if your range is called LastNames and the word you're checking for is =
in D1, use

=3DIF(COUNTIF(LastNames,D1)>0,D1,"")


Dan

-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx]On
Behalf Of Robert Carneal
Sent: 20 December 2004 17:04
To: mso@xxxxxxxxxxxxx
Subject: [mso] Check for existence in column? Excel 2000 [Scanned]


I am looking for a variation of vlookup, please. If I have a column =
called
LastNames, and some names below it such as:

LastNames
Apple
Banana
Conkright
Davidson

How do I check that simply for the existence of a name? If I want to see =
if
"Smith" is in that list, everything I check so far seems to want me to =
refer
to the column next to it. I.e.,
=3Dvlookup("Smith",LastNames, 0)
will not work.

=3Dvlookup("Apple",:LastNames,1)
returns whatever is in the cell next to it, which is not what will work
here.

Does anyone know how take a cell reference, check for its existence, =
return
the name if exists, return nothing if not?
Made up example:

=3DIf_Exists(B3, LastNames, B3,"")
would be lovely if there was such a function.
If B3 is "Apple", then it will return "Apple" since it exists.
If B3 =3D "Smith", then it returns a blank since it does not exist.

Am I making sense?

Thank you.

Robert

*************************************************************
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=20
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).
http://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
*************************************************************
*************************************************************
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).
http://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: