If Statement and a List
 

I have a column with 100 names in it. Of those names, 6 are part of a
special category. The column with 100 names gets updated automatically via
macro, while the 6 names category rarely changes. If they do change, I will
manually update the list.

What I want to do is write an IF function that says, if one of the 100 names
appears in the special list of six, I want the function to return "Yes", if
not, "No".

Any suggestions?

If Statement and a List
 

Try something like this:

=IF(SUMPRODUCT(COUNTIF(A1:A8,C1:C3))0,"Yes","No")


--
Cheers,
Shane Devenshire


"mikesaysgobears" wrote:

I have a column with 100 names in it. Of those names, 6 are part of a
special category. The column with 100 names gets updated automatically via
macro, while the 6 names category rarely changes. If they do change, I will
manually update the list.

What I want to do is write an IF function that says, if one of the 100 names
appears in the special list of six, I want the function to return "Yes", if
not, "No".

Any suggestions?

If Statement and a List
 

Try this:

A1:A100 = names
G1:G6 = special category names

=IF(SUMPRODUCT(--(ISNUMBER(MATCH(A1:A100,G1:G6,0)))),"Yes","No")

Biff

"mikesaysgobears" wrote in
message ...
I have a column with 100 names in it. Of those names, 6 are part of a
special category. The column with 100 names gets updated automatically
via
macro, while the 6 names category rarely changes. If they do change, I
will
manually update the list.

What I want to do is write an IF function that says, if one of the 100
names
appears in the special list of six, I want the function to return "Yes",
if
not, "No".

Any suggestions?

If Statement and a List
 

Thanks - I would like to apply this formula to each of the 100 names;
however, this formula does not refer to the cells in the list.


"ShaneDevenshire" wrote:

Try something like this:

=IF(SUMPRODUCT(COUNTIF(A1:A8,C1:C3))0,"Yes","No")


--
Cheers,
Shane Devenshire


"mikesaysgobears" wrote:

I have a column with 100 names in it. Of those names, 6 are part of a
special category. The column with 100 names gets updated automatically via
macro, while the 6 names category rarely changes. If they do change, I will
manually update the list.

What I want to do is write an IF function that says, if one of the 100 names
appears in the special list of six, I want the function to return "Yes", if
not, "No".

Any suggestions?

If Statement and a List
 

Hi Mike,

I'm not sure what you mean by this formula does not refer to the cells in
the list.

In the example I sent the A1:A8 is your long list and C1:C3 is your short
list. Just replace these with the addresses of your two ranges.

=IF(SUMPRODUCT(COUNTIF(A1:A8,C1:C3))0,"Yes","No")

Cheers,
Shane Devenshire


"mikesaysgobears" wrote:

Thanks - I would like to apply this formula to each of the 100 names;
however, this formula does not refer to the cells in the list.


"ShaneDevenshire" wrote:

Try something like this:

=IF(SUMPRODUCT(COUNTIF(A1:A8,C1:C3))0,"Yes","No")


--
Cheers,
Shane Devenshire


"mikesaysgobears" wrote:

I have a column with 100 names in it. Of those names, 6 are part of a
special category. The column with 100 names gets updated automatically via
macro, while the 6 names category rarely changes. If they do change, I will
manually update the list.

What I want to do is write an IF function that says, if one of the 100 names
appears in the special list of six, I want the function to return "Yes", if
not, "No".

Any suggestions?