Help

Re: Formula to lookup whether a lookup field contains a value

Solved
Jump to Solution
896 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Alastair_Budge1
6 - Interface Innovator
6 - Interface Innovator

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?
1 Solution

Accepted Solutions
Databaser
12 - Earth
12 - Earth

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")

 

See Solution in Thread

2 Replies 2
Databaser
12 - Earth
12 - Earth

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")

 

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