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

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
AndreamaryAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Santosh GuptaConnect With a Mentor Commented:
Pls try below,


=IF(L1="","",IF(RIGHT(L1,3)="NEW","NEW","REVISED"))
0
 
AndreamaryAuthor Commented:
Perfect...and thanks for answering so quickly!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.