Inserting a list into "If" function

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"
 
M

Max

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
 
P

Per Jessen

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop down list control value in vba 2
Drop down lists in seperate columns 5
How to link seperated documnet into a single document 0
Filtered drop down list 2
Link a text box based on drop down box with four options MS Word 365 0
Transpose: many columns to inserted rows 0
Adding a big matrix in Word 2013 5
Using Drop Down list to an If Statement to another Drop Down list 3

Top