Search formula

[lapta301]

Sorry to bother you but I need a bit of help in adjusting the following formula.


=IF(COUNT(SEARCH("*"&"AB"&"*"," "&$H2&" "))>0,"Bristol","")


At present it is looking for the letters AB in whatever string is in H2 and placing Bristol in the cell if successful.

What I now need to achieve is for the search in H2 to find either AB or CO or C0 and if found insert Bristol

As ever I hope this makes sense and my thanks for your help.

 

[Rick Rothstein]

Give this a try...

=IF(COUNT(SEARCH("*"&{"AB","CO"}&"*"," "&$H2&" "))>0,"Bristol","")

 

[lapta301]

Rick

What can I say.

You've come up trumps again it works perfectly and adds a lot of flexibility for future use of which I am sure I will need.

My sincere thanks for taking the time.

Regards from a gloomy Southern England.