Inserting a list into "If" function

  • Thread starter Thread starter MZ
  • Start date Start date
M

MZ

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"
 
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
 
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
 
Back
Top