Returns of Lookup Tables in formulas

[Mathias_Deichmann]

I cant understand why this formula doesn’t return: “LEGO” (The data) instead of a grid value for the “Brand” column (Its a lookup table).
This is probably so simple, but I cant seem to find the answer. Or is it a bug?

I hope somebody can help, Thnaks
-Mathias

[Ander]

@Mathias_Deichmann

Try Concatenate() instead of using “+”.

[Mathias_Deichmann]

Thank You - Thats exactly what was needed.