Populate excel fields with data based on matching numbers from other sheet

[River99]

Hello.

On sheet 1 there are 2 columns: Customer number, email adress.
On sheet 2 there are 2 columns: Customer number, sales representative.
(it's the same customer numbers on sheet 1 and 2)

I need to combine the sheets so that it shows Customer number, email adress AND sales representative.

Basically adding a column in sheet 1 named sales representative and then use some function to look for the corresponding customer number in sheet 2, fetch who is the sales rep and then add it to sheet 1.

Adding an excel-file as an example on what I mean.

Thank you so much in advance for any help!!!!

[Kaper]

In Sales Rep cell C2:

Please Login or Register  to view this content.

and copy down