Hi All,
I have a number for example 33034P7 in cell A1
In B1 if the value in A1 has a P in it I want it to return the word "Finished Goods"
I have been experimenting with the below formula but can't get it to work. Any suggestions?
=IF(ISNUMBER(SEARCH("P",A1,)),"Finished Goods","")
You have a comma in there that you don't need:
=IF(ISNUMBER(SEARCH("P",A1)),"Finished Goods","")
otherwise it looks okay to me.
Pete
=IF(ISNUMBER(SEARCH("P",A1,)),"Finished Goods","")
No nned of the comma there--Red bold_
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Remove the comma after A1...
=IF(ISNUMBER(SEARCH("P",A1)),"Finished Goods","")
Here's another way...
=IF(COUNTIF(A1,"*P*"),"Finished Goods","")
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Try
=IF(ISNUMBER(SEARCH("P",A1,1)),"Finished Goods","")
or just
=IF(ISNUMBER(SEARCH("P",A1)),"Finished Goods","")
How about
=IFERROR(IF(FIND("P",A1)>0,"Finished Goods",""),"")
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Something wrong with the Forum today - none of these replies show up on the list of New Posts, and my post count hasn't increased. It has happened with several of my posts today.
Pete
Hi
Try this formula:
=IF(ISNUMBER(FIND("P",A1,1)),"Finished Goods","")
Good luck.
Tony
Yeah, I also noticed that but it seems to have updated in the last few minutes.
Pete,
Its showing correctly in the New posts now. Maybe just a small glitch. We already faced a hacking attack today. This could be one of the after-effects.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Brilliant, thanks everyone.
You're welcome. We appreciate the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks