Inserting a list into "If" function
 

Column A has a long list of items that I use in a drop-down list that I named
"CreatureList"
How can use the "If" function and/or other functions to test for two or more
arguments without having to insert the names of the individual items in the
list into the arguments of the formula?

Example:

Column A drop down list, entitled "CreatureList"

Cats
Dogs
Horses
Sharks
etc.

Describing the function:
If any of the 20 animals from the Creature list, then insert "Mammals"; if
any other creature from the list, then insert "Fish"




--
MZ

Inserting a list into "If" function
 

Perhaps you're hunting for something like this ...
Assuming source creatures listed in A2 down
In B2: =IF(A2="","",IF(COUNTIF(CreatureList,A2),"Mammals" ,"Fish"))
Copy down. On target? jab the YES button below
--
Max
Singapore
---
"MZ" wrote:
Column A has a long list of items that I use in a drop-down list that I named
"CreatureList"
How can use the "If" function and/or other functions to test for two or more
arguments without having to insert the names of the individual items in the
list into the arguments of the formula?

Example:

Column A drop down list, entitled "CreatureList"

Cats
Dogs
Horses
Sharks
etc.

Describing the function:
If any of the 20 animals from the Creature list, then insert "Mammals"; if
any other creature from the list, then insert "Fish"

Inserting a list into "If" function
 

Hi

With CreatureList in column A, enter Mammals/Fish in column B for each
creature, then use a Lookup function to get the 'type'.

Suppose you have the drop-down list in E1, use this formula:

=IF(E1<"",LOOKUP(E1,CreatureList,B1:B4),"")

Regards,
Per

"MZ" skrev i meddelelsen
...
Column A has a long list of items that I use in a drop-down list that I
named
"CreatureList"
How can use the "If" function and/or other functions to test for two or
more
arguments without having to insert the names of the individual items in
the
list into the arguments of the formula?

Example:

Column A drop down list, entitled "CreatureList"

Cats
Dogs
Horses
Sharks
etc.

Describing the function:
If any of the 20 animals from the Creature list, then insert "Mammals"; if
any other creature from the list, then insert "Fish"




--
MZ