| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If Statement and a List
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If statement with validation list | Excel Worksheet Functions | |||
| list embedded in an if statement | Excel Discussion (Misc queries) | |||
| adding a drop down list to an If Statement? | Excel Worksheet Functions | |||
| If statement with a drop down list | Excel Discussion (Misc queries) | |||
| Drop down list with an if statement | Excel Worksheet Functions | |||
Threaded Mode
