Is my syntax wrong in IF formula for Lookup column?

Hi there Airtable community!

I’m having trouble with an IF statement. I have a lookup column with two values, Turned or H/L. If the value is Turned, I want my formula to add the values in each of the shoe sizes listed. I’m getting an ERROR every time I try it though. Is it because the value (H/L) is a lookup value? The formula saves correctly, but the resulting value is #ERROR!

Screenshot attached too…

thanks for your help :slight_smile:

SEARCH(“H/L”, {Toe Puff}),

Ah… thanks to @Neads_Admin on this thread

I added ARRAYJOIN and the searching of the lookup field worked. Nice!

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.