If statement or Find statement?

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

Can you explain the last two terms in your expression, i.e.:

...,IF(ISNUMBER(SEARCH("**",F2)),"1",IF(ISNUMBER(SEARCH("**",F2)),"","")))))

as these seem to be the same condition. How does G2 and F2 relate to the other cells in your sample workbook? Do you really want the text value "1" returned, or should it be the number 1?

Pete