Is my syntax wrong in IF formula for Lookup column?

[Emma_Garwood]

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 :slightly_smiling_face:

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

[Emma_Garwood · Accepted solution]

Ah… thanks to @AlliAlosa on this thread

Help with SEARCH() Formula Ask the community

I am super confused here… does the SEARCH() formula function not work when performed on a Lookup field? The following formula performs correctly on the table containing the field {Description}, but NOT on the table which looks up the field {Description}. IF(OR(SEARCH("HINO", Description) > 0, SEARCH("ISUZU", Description) > 0), "!", "")

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