Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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" |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text "comparison" operator for "contains" used in an "IF" Function | Excel Worksheet Functions | |||
Inserting a cell value from an "IF" function | Excel Worksheet Functions | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
cannot use "Create List" and "Share Workbook" same time | Excel Discussion (Misc queries) | |||
inserting a conditional "go to" command on a excel "if" function | Excel Worksheet Functions |