If cell contains specific text, then return a value

Cross-posted at https://www.mrexcel.com/board/thread...value.1226621/

Hello all,
I need some help.

I have an small excel with 5 rows and I need a formula that inserts a fix date.

The rows are:
Location-task-status-pending-completed

On the status row I have a drop-down menu with 3 options(new,pending,done)

What I exactly need is to convert this formula into a fix date:

=IF(cell="text", value_to_return, "")


So if in ?status row? I choose ?done option?, in the ?completed row? it shows the date this option was chosen.

Where ?value to return? is a fix date for the option chose on status and does not change unless you change on the drop-down menu.
I am attaching a screen shoot.



I thanks you in advace for you help.

Best.
Captura 1.PNG

We are having problems displaying some special characters in posts, and they are displayed as "?" characters. Just use " and ' characters instead.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important: https://excelguru.ca/a-message-to-forum-cross-posters/

I have added it for you since it's your first post.

There is VBA solution posted in the other thread and you said it works.

If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."