<div>
Perfect...and thanks for answering so quickly!
</div>


<div>
<div class="content wysiwyg-content">
Column L contains text strings of various lengths. Column S has data validation that includes the following words in the dropdown menu: NEW, REVISED, DELETED. <br />
<br />
I want to create a formula that changes the value in Column S if specific criteria are met in Column L as follows:<br />
<br />
If the text string in column L ends with &quot;- NEW&quot;, then the cell in Column S (in same row) autopopulates with the word &quot;NEW&quot;.<br />
<br />
If text string in column L does not end with &quot;- NEW&quot;, &nbsp;then the cell in Column S (in same row) autopopulates with the word &quot;REVISED&quot;<br />
<br />
If cell in column L is blank, then the cell in Column S (in same row) remains blank.<br />
<br />
Thanks!<br />
Andrea
</div>
</div>


Column L contains text strings of various lengths. Column S has data validation that includes the following words in the dropdown menu: NEW, REVISED, DELETED. 

I want to create a formula that changes the value in Column S if specific criteria are met in Column L as follows:

If the text string in column L ends with "- NEW", then the cell in Column S (in same row) autopopulates with the word "NEW".

If text string in column L does not end with "- NEW",  then the cell in Column S (in same row) autopopulates with the word "REVISED"

If cell in column L is blank, then the cell in Column S (in same row) remains blank.

Thanks!
Andrea

Changing value in one cell based on last part of text string in another cell

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Office Productivity refers both to the act of being productive and efficient in an office or professional environment, as well as the software applications used to "produce" information. This includes the development of professional skills, creating work processes, and almost any program used to create or modify a document, image, audio or video clip. However, business application suites such as Microsoft Office, which include word processing, spreadsheet and presentation programs, are typically called productivity software, as contrasted with a "utility program," such as a file manager, which is used to organize files and folders on the computer. Many office- and business-oriented groups of programs are organized into suites.