Hello,
I am using the formula below to search for text within a cell and return a specific value.
For example, if the text within a cell contains "1 lb bag" the value returned will be "lb". Is it possible to add more arguments and return different values based on what it finds? For example, if the cell contains "10 oz" it will return a value of "oz" instead of "lb"?
=IF(ISNUMBER(SEARCH("lb",J22)),"lb","")
Thank you in advance.
How many search words do you have?
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
One way:
With a list of key words in E2 to E6, and data beginning in A2:
=IFERROR(LOOKUP(10^10,SEARCH(E$2:E$6,A2),E$2:E$6),"")
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Currently four, but could possibly have one or two more in later iterations.Originally Posted by Tony Valko
Glenn's suggestion should do what you want.
Fantastic - this works great. Thank you!
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
But, of course, it had been your suggestion in a previous post!!
“Imitation is the sincerest form of flattery that mediocrity can pay to greatness.”
Oscar Wilde...
'''''''''''''''
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks