Excellant, both approaches work a treat.

I now need to join this with another formula that I have.

I have this formula:

=IF(ISNUMBER(SEARCH("*hotel*",G2)),"1",IF(ISNUMBER(SEARCH("*motel*",G2)),"1",IF(ISNUMBER(SEARCH("*pork*",G2)),"1",IF(ISNUMBER(SEARCH("*beef*",G2)),"1",IF(ISNUMBER(SEARCH("*chicken*",G2)),"1",IF(ISNUMBER(SEARCH("*lamb*",G2)),"1",IF(ISNUMBER(SEARCH("**",F2)),"1",IF(ISNUMBER(SEARCH("**",F2)),"","")))))

this is saying inthe cell where you are picking up "Coffee", if it says Hotel, Motel, pork, beef, chicken, lamb then bring back 1.

Is there a way of joining the 2 together, as I need this hierarchy to sort the importance of servicing by company!!

Cheers for your help

Donna