My knowledge of excel is fairly basic so I'm hoping someone can help me.
I have 2 spreadsheets both containing lists of the same items.
The description of these items is 3 words eg:
A1 = blue, B1 = coat, C1 = large
A2 = green, B2 = jumper, C2 = medium
A3 = green, B3 = coat, C2 = small...