First off... thanks so much for looking into this issue!! Here's my problem....
I have a spreadsheet wherein I have a contact name in column b, one status type in column c, another status type in column d, and I want an action in column e to be automatically populated based upon the values of the contents in columns c and d.
Here's the possible status and their associated action item:
(Col C | Col D | Col E)
Yes | Yes | No further follow-up required
Unknown | Yes | Contact to confirm
Unknown | Unknown | Still need to track down
Unknown | No | Contact for updates
No | No | No further follow-up required
No | Yes | No further follow-up required
So how would I go about setting this up? Thanks so much for all your inputs!!! I really appreciated it!!
I have a spreadsheet wherein I have a contact name in column b, one status type in column c, another status type in column d, and I want an action in column e to be automatically populated based upon the values of the contents in columns c and d.
Here's the possible status and their associated action item:
(Col C | Col D | Col E)
Yes | Yes | No further follow-up required
Unknown | Yes | Contact to confirm
Unknown | Unknown | Still need to track down
Unknown | No | Contact for updates
No | No | No further follow-up required
No | Yes | No further follow-up required
So how would I go about setting this up? Thanks so much for all your inputs!!! I really appreciated it!!