Let formula for text

[darkhangelsk]

Hello,

I have a "LET" formula trying to use, however, i got an error whenever I put a text on the first column.

This is use for data validation, so i can remove the unique values and it is based on the data from "Shift" then "Group" headers.

Thank you in advance!

 

[Fluff]

You're welcome & thanks for the feedback.