Any Excel Experts Out There?

doubledragonxx

Distinguished Member
Joined
Jan 17, 2007
Messages
3,522
Reaction score
808
Points
1,009
Age
47
Possibly doesn't even need an Excel expert just someone with more Excel knowledge than me which can't be difficult tbh :D .

So looking for some help with this formula =IF(SEARCH("-P",Sheet1!I923),"X","")

The forumla does the job but for the false value I get a #Value! rather than "" (which should I believe return a blank)

Any pointers where I am going wrong.
 
Search returns #VALUE! when the item being searched for isn't found.

You could use =IF(ISERROR(SEARCH("-P",Sheet1!I923)),"","X")

May cause other problems if the target cell of the search isn't TEXT though!


:smashin:
 
Note that cell being intergorated e.g. Sheet1!I923 is filled with text in no particular format.
Search returns #VALUE! when the item being searched for isn't found.

You could use =IF(ISERROR(SEARCH("-P",Sheet1!I923)),"","X")

May cause other problems if the target cell of the search isn't TEXT though!


:smashin:
You my friend are a genius, works perfectly now!

Thanks, really appreciated.
 
Honestly 14 years you have been here and you ask if there are any experts?
This is GC, everyone's a bloody expert
:rotfl: :rotfl:
 

The latest video from AVForums

TV Buying Guide - Which TV Is Best For You?
Subscribe to our YouTube channel
Back
Top Bottom