Posted to microsoft.public.excel.worksheet.functions
|
|
Question on which function to use
See this:
http://contextures.com/xlFunctions02.html
--
Biff
Microsoft Excel MVP
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?
|