Any Excel Experts Out There?

doubledragonxx

Well-known Member
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.
 

BandWidthJunkie

Well-known Member
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:
 

doubledragonxx

Well-known Member
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.
 

John

Moderator
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

Podcast: Panasonic JZ2000 Final Thoughts - TV Calibration: Should you? And More...
Subscribe to our YouTube channel
Support AVForums with Patreon

Top Bottom