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