Hi,
Please can someone help - I think I need some sort of vlookup / match / index solution?
Basically what I need to do is fill the yellow column with the relevant data from the orange column.
For example: Where it has Sarah Lauder in cell A43, I want to populate cell C43 with the value...