Formula to lookup whether a lookup field contains a value

[Alastair_Budge1]

I'm trying to write a formula to check whether a lookup field contains a specific value.

These lookup fields might contain one or multiple values, e.g.

1. apples
2. apples, pears
3. pears, bananas, strawberries

I've been using the formula 

IF(FIND("apples", {fruitName}), "yes", "no")

In this case, I would expect 1 and 2 to return as "yes", but only 1 is returning yes. Find seems to require an exact match, and if there are other values in the lookup field, it returns false. 

Does anyone know what I'm doing wrong here?

[Databaser · Accepted solution]

The FIND() function works with strings, not arrays. So add &"" to convert the data of your lookup field into a string. 

IF(FIND("apples", {fruitName}&""), "yes", "no")

[Alastair_Budge1]

Amazing, this worked perfectly. Thank you very much @Databaser