Hi,
Please use the VLOOKUP() function. Please formulate as follows in cell C1
=VLOOKUP(A1,[Book3]Sheet1!$A$1:$B$3,2,0)
--
Regards,
Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
wrote in message
...
I have two files files that contain employee information. Each file
has an employee number.
I wish to compare the employee records in the two files using the
employee number and copy selected fields to one of the files.
For example,
File #1
A B C D E
1 32 Bob
2 65 Sam
3 77 Cal
File #2
A B C D E
1 32 Smith
2 65 Jones
3 77 Doe
I would like a function that would compare the two files using column
A. The outcome would be that the entries in column B of file #2 would
be placed in coulmn C of file 1 assuming the ID's found in coulmn 1
match.
Which function would I use? And how would the formula be written in
the example above?