|Still a bit confused.|
You have two key words your searching for: Cheese and Jack
If the adjacent cell does not contain your key word, you simply want Cheese?
What is it your trying to do? It does not seem to make any sense to me.
With your data like:
2) American Cheese
4) Cheddar cheese
You want something like:
A B C
1) Beef Cheese
2) American Cheese American Cheese
3) Lettuce Cheese
4) Cheddar cheese Cheddar cheese
If that is correct, then change your formula like: