Will VLookup work

Hello friends

I have two sheets as follows

The first sheet contains Names of Employees of about 600 employees

The second sheet contains Names and Employee Number of 1000 employees which also includes the above 600.

I want to add a new column in the firs sheet as Employee Number and want to export the data against each of the 600 employees. How do I do this ?

Originally Posted by daffodil11

Let's pretend you're working with Sheet1 and Sheet2.

A1 = the first name

B1 = VLOOKUP(A1,Sheet2!$A$1:$B$1000,2,0)


and copy down

Thanks. it does not seem to work. Maybe I was not clear in my explanation. I have the following data in Sheet 1
A1: A600 - Names of Employees

Sheet2

A1:A1000 - Names of Employees
B1:B1000 - Employee Numbers

I want to insert a new column B1 in Sheet1 and import the data from Sheet 2 for those names which matches the names of employees. In other words it should import only the 600 employee numbers that matches with the 600 names of employees.

Can you or someone please help. I need this urgently to complete this morning.

Thanks my friend. I will try to figure it out. Your help is much apprecaited.