jjdwhitfield
Board Regular
- Joined
- Aug 13, 2008
- Messages
- 64
I am trying to do a multiple seach. The below works but I have tried various options using OR.... Any ideas would be appreaciated.
=IF(SEARCH("MGT",$G8),"TRUE","FALSE")
I have tried
=IF(OR(SEARCH("MGT",$G8),"TRUE","FALSE"),(SEARCH("TL",$G8),"TRUE","FALSE")
AHHHH
Any help greatly appreciated
Kind Regards
Jon
=IF(SEARCH("MGT",$G8),"TRUE","FALSE")
I have tried
=IF(OR(SEARCH("MGT",$G8),"TRUE","FALSE"),(SEARCH("TL",$G8),"TRUE","FALSE")
AHHHH
Any help greatly appreciated
Kind Regards
Jon