If text contains different things

[hanif]

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

[tim201110]

=iferror(lookup(2,1/search($a$1:$a$3,c1),$b$1:$b$3),"")
in a1:a3 are your words
in B1;B3 - Equipment Fuel

[hanif]

Thanks but didn't work properly. Is there a way to modify the formula I got there?

=iferror(lookup(2,1/search($a$1:$a$3,c1),$b$1:$b$3),"")
in a1:a3 are your words
in B1;B3 - Equipment Fuel

[tim201110]

it does work

[Syrkrasi]

Try this formula
=IF(OR(H2={"Diesel","petrol","fuel"}),"Equipment Fuel","")

[hanif]

Thank you Tim, I see what you did there.

it does work