one option is VLOOKUP:

=VLOOKUP(Sheet1!Emp_ID,Sheet2!A2:B100,2,FALSE)

Assuming Column A in Sheets 1 & 2 contain the ID, then the above will match
the IDs and place the contents of Column B (from Sheet2) into the cell where
the VLOOKUP formula is placed. The <2 tells VLOOKUP to take the 2nd value
in the table i.e defined as A2:B100


=VLOOKUP(Sheet1!Emp_ID,Sheet2!A2:C100,3,FALSE) will select value from Column C


Simply copy this formula down in columns as required.

HTH

"CathyW" wrote:

I have data in two sheets that I need to combine and match using a unique ID
number. For example, it is a list of employees and on one sheet I have birth
date and on the other sheet I have addresses. The ID is on both sheets. How
do I move the data from one sheet onto the other, making sure the data
matches the ID?