Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If referencing drop-down list
Hello fellow helpers,
I wrote the following formula to fill in the direction for a help request (there are two teams working on the helpdesk) that I thought would fill in the cell once the corresponding drop-down list was filled in (cell h3). It is not working. Can anyone tell me why? =IF(AND(H3="Add New Resource",H3="Update Resource",H3="Project Rename",H3="Project Check-In",H3="Project Delete",H3="Change Plan Owner",H3="Request Project Manager Permissions",H3="Request Remote Desktop Access"),"Send to PRISMhelp",IF(AND(H3="Error Message",H3="Project Workplan Questions",H3="PWA Time Entry Questions",H3="Resource Center Questions",H3="Project Center Questions",H3="Portfolio Analyzer Questions",H3="Cannot access PWA",H3="Cannot access PWA Project Professional"),"Product Delivery PRISM","")) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If referencing drop-down list
You may just need to change the ANDs to ORs; there's no chance that H3="Add
New Resource" AND, at the same time, H3="Update Resource". --Bruce "Nicole Seibert" wrote: Hello fellow helpers, I wrote the following formula to fill in the direction for a help request (there are two teams working on the helpdesk) that I thought would fill in the cell once the corresponding drop-down list was filled in (cell h3). It is not working. Can anyone tell me why? =IF(AND(H3="Add New Resource",H3="Update Resource",H3="Project Rename",H3="Project Check-In",H3="Project Delete",H3="Change Plan Owner",H3="Request Project Manager Permissions",H3="Request Remote Desktop Access"),"Send to PRISMhelp",IF(AND(H3="Error Message",H3="Project Workplan Questions",H3="PWA Time Entry Questions",H3="Resource Center Questions",H3="Project Center Questions",H3="Portfolio Analyzer Questions",H3="Cannot access PWA",H3="Cannot access PWA Project Professional"),"Product Delivery PRISM","")) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If referencing drop-down list
Change AND to OR both places in your formula. You want it to return "Send to
PRIZMhelp" if H3="Add New Resource" OR if H3="Update Resource", etc. Only one condition can be true at a time for H3. Hope this helps, Hutch "Nicole Seibert" wrote: Hello fellow helpers, I wrote the following formula to fill in the direction for a help request (there are two teams working on the helpdesk) that I thought would fill in the cell once the corresponding drop-down list was filled in (cell h3). It is not working. Can anyone tell me why? =IF(AND(H3="Add New Resource",H3="Update Resource",H3="Project Rename",H3="Project Check-In",H3="Project Delete",H3="Change Plan Owner",H3="Request Project Manager Permissions",H3="Request Remote Desktop Access"),"Send to PRISMhelp",IF(AND(H3="Error Message",H3="Project Workplan Questions",H3="PWA Time Entry Questions",H3="Resource Center Questions",H3="Project Center Questions",H3="Portfolio Analyzer Questions",H3="Cannot access PWA",H3="Cannot access PWA Project Professional"),"Product Delivery PRISM","")) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop down list as part of a file name selector | Excel Discussion (Misc queries) | |||
Conditional Drop Down List | Excel Discussion (Misc queries) | |||
Populating worksheet via a drop down list ! | Excel Worksheet Functions | |||
Limit drop down list and linking to other info | Excel Worksheet Functions | |||
Drop List Referencing | Excel Worksheet Functions |