Hi All,

I used the following formula to say if H2 contains words diesel or petrol or fuel then return 'Equipment Fuel'. It does work for cells contain diesel but not for petrol and fuel. Does anyne know where I did it wrong?

=IF(ISNUMBER(SEARCH({"Diesel","petrol","fuel"},H2)),"Equipment Fuel","")

Thanks