I have 2 different excel. Excel 1 is with all the company name with their branch company names and sales person names. Every sales person has different excels by their name. I have to take the sales target column from sales person excel and put it in excel 1. I made a sample excels and put the screenshot here.
I guess it's a VLOOKUP, but not sure how to do this since I have to match the company and branch name. Now how can I match the company name, parent company and sales person, then generate the target sales column in excel 1.
Any suggestion or help appreciated.
Thank you!
=A2 & B2 & C2
to form a single unique lookup key.