Covert,

Take look at the VLOOKUP spreadsheet function, I think this will do what you
want.

HTH/

"Covert" wrote:

I have two excel spreadsheets. One is the raw data (employee names and file
number), one is a list (various employee names with other data information).

How can I get the data from the employee names and file number spreadsheet
to match and merge into the raw data spreadsheet. The raw data has employee
names but rather than type in the employee file number can Excell match and
merge? If so, how can I accomplish this.