Merging data from two worksheets?

[legal_eagle]

Ok here's the problem, any help would be much appreciated.

I have two worksheets. Both have a common identifier (staff I
number).

On worksheet 1 I have the staff ID numbers and lots of other column
that I require, name, grade, start date etc.

On worksheet 2 I have I also have the staff ID numbers, some othe
columns I don't need and one that I do, which is 'ethnic origin'.

What I need to do is merge the two so that I have all the data i
worksheet 1 with the ethnic origin column and corresponding data tagge
on to the end. Short of going through all the thousands of rows an
manually entering the ethnic origin data into a new column, what are m
options?

I can't cut and paste and then sort because although the vast majorit
of staff id numbers are on both worksheets they are not identical
there are more on one than on the other.

What I really need excel to do is to look in worksheet 1 at the staf
id number, find the corresponding staff id number in worksheet 2 an
then take the ethnic origin data for that staff id number and paste i
into a new column in worksheet 1. If that makes any sense?

One again any help would be appreciated.

Thanks,
Tom

 

[Ken Wright]

Take a look at VLOOKUP. This allows you to take your staff ID number in your
master sheet and lookup the ethnic origin from the second sheet that is
associated with that ID. The help files will give you an example.

 

[BenjieLop]

Assuming that your worksheet 2 columns are arranged this way:

ColumnA ColumnB
StaffID Ethnic Origin

Your formula is:

=vlookup("CellNumber",Worksheet2!$A$1:$B$100,2,0)

where "CellNumber" is the cell address that has the specific *Staff ID
that you want looked up for the corresponding *Ethic Origin*

AND *$A$1:$B$100 * is the assumed range of your data in Worksheet 2
You can modify this range according to your actual tabl
configuration.

Hope this will help you out.