Solved

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

Posted on 2014-03-15
2
375 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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

With the internet and the ease of information transference, many professional jobs can be done anywhere today.  Why should it make a difference whether an x-ray is read in India or the United States as long as the radiologist is qualified?   Outso…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
XMind Plus helps organize all details/aspects of any project from large to small in an orderly and concise manner. If you are working on a complex project, use this micro tutorial to show you how to make a basic flow chart. The software is free when…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

839 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