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?
|