HELP! how to cross - data with excel??

[gloriamar]

Hi, I'm required to present some info at my work, using two excel files. This
is the task:

File 1, has ID numbers in column A, and column B is blank.

File 2, has ID numbers in column C and column D has the date the person
joined the company

File 1 es a select grop of people (about 2500), whereas File 2 is the
general database (about 30thou)

They're asking me to match the data, in order to end up with the
coresponding date they joined the company in column B on File 1 (obtained
from column D on file 2), how to do it? taking in account that File 1 is
outdated and some people might not be in file 2.

I would really appreciate any help you might give me.


Gloria

 

[Dave Peterson]

You have a response at one of your other posts.

Hi, I'm required to present some info at my work, using two excel files. This
is the task:

File 1, has ID numbers in column A, and column B is blank.

File 2, has ID numbers in column C and column D has the date the person
joined the company

File 1 es a select grop of people (about 2500), whereas File 2 is the
general database (about 30thou)

They're asking me to match the data, in order to end up with the
coresponding date they joined the company in column B on File 1 (obtained
from column D on file 2), how to do it? taking in account that File 1 is
outdated and some people might not be in file 2.

I would really appreciate any help you might give me.

Gloria

 

[Tom]

Hi, I'm required to present some info at my work, using two excel files.
This
is the task:

File 1, has ID numbers in column A, and column B is blank.

File 2, has ID numbers in column C and column D has the date the person
joined the company

File 1 es a select grop of people (about 2500), whereas File 2 is the
general database (about 30thou)

They're asking me to match the data, in order to end up with the
coresponding date they joined the company in column B on File 1 (obtained
from column D on file 2), how to do it? taking in account that File 1 is
outdated and some people might not be in file 2.

I would really appreciate any help you might give me.

Hello Gloria,

Assuming Files 1 and 2 are separate workbooks

Go to File 2 and copy everything from columns C and D, and paste it into
cell A1 of an empty sheet in File 1, while it's all still selected, right
click, pick "name a range", and call the range "date" (don't put the
quotation marks in). Close File 2, you don't need it any more.

Go to the sheet that has File 1, and in column B, cell 1, type (or copy and
paste this)

=VLOOKUP(A1,date,2,0)

Double click the autofill handle (or drag it down to the last cell in column
B)

All the id numbers that match from Files 1 and 2 should now have a date next
to them.

Hope this helps

Tom