Solved

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

Posted on 2014-03-15
2
372 Views
Last Modified: 2014-03-15
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
0
Comment
Question by:Andreamary
2 Comments
 
LVL 13

Accepted Solution

by:
Santosh Gupta earned 500 total points
ID: 39931743
Pls try below,


=IF(L1="","",IF(RIGHT(L1,3)="NEW","NEW","REVISED"))
0
 

Author Closing Comment

by:Andreamary
ID: 39931765
Perfect...and thanks for answering so quickly!
0

Featured Post

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I recently resolved a client's Office 2013 installation problem and wanted to offer an observation that may help you with troubleshooting similar issues. The client ordered three Dell Optiplex system units with the Windows 7 downgrade option inst…
Lately there has been a variety of news related to U.S. employment.  Stories about worker productivity, automobile and airline unions, low employment and foreign laborers have frequented the news.  Each story has good and bad attributes we might arg…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now