Question on which function to use

[kurchian]

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?

 

[T. Valko]

See this:

http://contextures.com/xlFunctions02.html

 

[Ashish Mathur]

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