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:

IF(
SEARCH(“H/L”, {Toe Puff}),
SUM({2},{2.5},{3},{3.5},{4},{4.5},{5},{5.5},{6},{6.5},{7},{7.5},{8},{8.5},{9},{9.5},{10},{10.5},{11},{11.5},{12},{12.5},{13},{14})
)

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.