I've tried to find the answer in the forum before posting but i cant seem to find it. Is there any function that would allow me to let excel tell me if a cell contains a certain value from a list of possibilities.

A
apple
banana
pear
carrot

possibilities
apple
banana
pear

if A2 is banana or apple or pear then B2 would contain a certain value that i will determine

hope my example is clear.
thanks a lot and if the answer is on the forum you can let me know and i will read it.