I have a file where Column A is a text. It is a free text, but no matter what the text is, it will always have XX or YY or ZZ values inside. And it always is going to be either one of those 3 values – never 2 or all 3 together.
What formula/function should I use in order to show in a separate column that if column A contains:
XX value, the returned result will be Bla-Bla.
YY should return boom-boom
ZZ should return bam-bam.
Thank you, guys!
What are the values for XX YY ZZ?
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
If you mean XX, YY, and ZZ literally, try the formula below:
=IF(IFERROR(FIND("XX",A1),0)>0,"Found XX",IF(IFERROR(FIND("YY",A1),0)>0,"Found YY",IF(IFERROR(FIND("ZZ",A1),0)>0,"Found ZZ","Nothing Found")))
Edit: I altered my initial post to account for errors and assume your text is in A1
Last edited by CAntosh; 04-22-2016 at 11:29 AM. Reason: initially posted wrong formula
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks