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.
=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.