Hi Richard,

Thanks for your reply.

I can't seem to adjust the formula for my data, could you do this for me?

In my first sheet the "line" column is E and "description" F
my second sheet is called "assortment.xlsx" and have its "line" column as A and description as B

Thank you!