Formulas with look up fields

[Sam_Horlock]

Hi there,

I am using a look up field in a formula (on another field).

The formula is just CONCATENATING the look up field, but I receive an #ERROR! when I try this. Is there a way around this.

Cheers!

Sam

[JonathanBowen]

Hi @Sam_Horlock - a lookup field actually returns an array of values or objects, so I think this could be the issue here. However, when I tried this with simple, single lookup values - numbers of strings - Airtable deals with it. Can you give some examples of the data you’re looking up and the formula you are using?

[Sam_Horlock · Accepted solution]

Hey Jonathan,

You’re correct, I have added an ARRAYJOIN to each lookup field referenced in the formula and it all worked out.

Thanks!