I have a list in column A and I want to search for a text in columns A string of text and return that text in column B. I used an IF(Search) statement and it worked for some rows but not all of them. how can i fix this?
I attached a sample
this is the IF statement in full:
=IF(SEARCH("Pharma",$A2),"Pharma",IF(SEARCH("MD&D",$AO3),"MD&D",IF(SEARCH("Consumer",$A2),"Consumer")))
thanks!
Maybe:
=IF(ISNUMBER(SEARCH("Pharma",$A2)),"Pharma",IF(ISNUMBER(SEARCH("MD&D",$A2)),"MD&D",IF(ISNUMBER(SEARCH("Consumer",$A2)),"Consumer","")))
Not sure why you were testing AO3 in your original formula.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
thanks it worked! the AO3 was a from my copy and paste from the original data
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks