Assigning Sales Team to Customers

[etheys]

Hello All,

I have a spreadsheet filled with data concerning this quarters sales (Customers, Qty's, Cost, etc). I have another spreadsheet with the Customer and the sales manager who handles the account. I need to assign the customers with their respective sales manager on the first spreadsheet.

Any help is much appreciated.

 

[Yahya]

could you post small sample from your data

 

[Ducky77ar]

=VLOOKUP(A1,'[AnotherSpreadsheet.xlsm]Sheet1'!$B:$C,2,0)

A1= Customer Name
Spreadsheet2 column B = Customers
Spreadsheet2 column C = Sales Managers