If formula, with a twist

[HeRoseInThree]

I have an if formula that has a variable. I'd like to search for a keyword (diesel) and if it is found, return a string. I thought about IF(F23="*diesel",S$33 but that didn't work.

Any ideas?

 

[Fluff]

That would go in the towing slot & you would use the same for the storage slot just changing the word to lookup.
If that is not what you want, then I'm out. As I have no idea what you are trying to do.

 

[jtakw]

Are you not reading my post #21 and #26 ???

 

[HeRoseInThree]

Are you not reading my post #21 and #26 ???

I am reading them, they just aren't working.

 

[jtakw]

Plug my formula in post #26 in the sample you showed in post #22, what results do you get, how is it not working?

 

[HeRoseInThree]

That would go in the towing slot & you would use the same for the storage slot just changing the word to lookup.
If that is not what you want, then I'm out. As I have no idea what you are trying to do.

This, I can work with! THANKS for your (everyone's) efforts!

 

[jtakw]

That would go in the towing slot & you would use the same for the storage slot just changing the word to lookup.
If that is not what you want, then I'm out. As I have no idea what you are trying to do.

This, I can work with! THANKS for your (everyone's) efforts!

You like to do things the Hard way, I'm out.

My formula in Post #21 and #26 will do Exactly what you want Without the need to change the Keyword for Every Cell you put the formula in.....