Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Is my syntax wrong in IF formula for Lookup column?

Topic Labels: Formulas
Solved
Jump to Solution
310 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Screenshot 2021-06-11 at 11.26.15

1 Solution

Accepted Solutions
Emma_Garwood
5 - Automation Enthusiast
5 - Automation Enthusiast

Ah… thanks to @AlliAlosa on this thread

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

See Solution in Thread

1 Reply 1
Emma_Garwood
5 - Automation Enthusiast
5 - Automation Enthusiast

Ah… thanks to @AlliAlosa on this thread

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