Excel Data Merge

G

Guest

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.
 
G

Guest

Covert,

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

HTH/
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top