Hi,
I am have alot of data that i am trying to analyze and I need help with a text function. I am trying to search a text string in a cell for specific values and return a specific value. An example of the text strings would be:
Oct 2011 Travel Supp
Sep 2012 Travel
Oct 2012 Travel Sup
I am trying to get a formula to search these text strings for the word "travel" and then return a value of "travel invoice". Is this possible? Any help would be greatly appreciated.
One way...
=IF(COUNTIF(A1,"*Travel*"),"Travel Invoice","")
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Maybe:
=IF(ISNUMBER(SEARCH("Travel", A1)), "Travel Invoice", "")
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Thanks!! Would it be possible to add multiple searches. For example if I had the same thread but also had some other types of invoices:
Oct 2011 Travel Supp
Sept 2013 Visas
Sep 2012 Travel
Oct Visas
Oct 2012 Travel Sup
Try this one
=LOOKUP(10^308,SEARCH({"travel","visa"},A1),{"Travel Invoice","Visa Invoice"})
Row\Col Oct 2011 Travel Supp Travel Invoice Sep 2012 Travel Travel Invoice Oct 2012 Travel Sup Travel Invoice Oct 2011 Travel Supp Travel Invoice Sept 2013 Visas Visa Invoice Sep 2012 Travel Travel Invoice
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks