In the attached worksheet sheet 1 column A displays the list of customers. You will see there are duplicates of each customer throughout.
Sheet 2 displays the list of customers without the duplicates but also includes some other important information about each customer.
Column 'L' = customer name
Column 'M' = market category
column 'N' = rank
How do I match the information for each customer on sheet two to the customer names in sheet 1.
For example I want DRAKE TOOLING & ABR. LT Cutting Tools 28
to display next to every duplicate row of DRAKE TOOLING in Sheet 1.
I want to do this for every customer.
I am a complete novice to excel. I believe it would involve using the vlookup function but I have little experience of this?