Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If then
Hello,
I would like to ask for help with a formula. I report onto a second sheet the referenced cell unless it meets one of the following criteria. For example: If "Sales_Opportunity_Input!CR1" = OPPown then Opportunity Owner, or if "Sales_Opportunity_Input!CR1" = close date then Close Date, or if "Sales_Opportunity_Input!CR1" = start then Comm. Start Date, or if "Sales_Opportunity_Input!CR1" = end, then Comm. End Date but if non of the creiteria are met, then show the data in Sales_Opportunity_Input! Thanks in advance for the help. I appreciate the time. Jim |