Joining two datasheets on common ID...

**RynMan** · 01-28-2009, 02:40 AM

Hi guys

I have a bunch of data - some on one sheet, some on another.

Sheet A has more data.

Sheet B has data that will be on Sheet A....and has less data.

Both information for each person has a common ID number on each sheet.

I need it to basically copy the data from Sheet B, and place it accordingly (to the right....extending the number of columns) in line with it's corresponding number on Sheet A. If this were in Access, it would be a query and a LEFT JOIN.

Not sure how in Excel!

Many thanks for your help...

**vandanavai** · 01-28-2009, 03:06 AM

Hello

I am not clear about ur requirement. But u may use Vlookup fuction. Or upload sample file for better understanding of problem.

**JBeaucaire** · 01-28-2009, 03:18 AM

Make sure the ID is on the leftmost column of Sheet B, then a VLOOKUP formula should do it.

Add the appropriate column names to Sheet A for the data you're bringing across. If on SheetA - A2 is the ID to match, then in the first column, enter a formula like:

=VLOOKUP(A2,SheetB!$A$2:$G$200,4,FALSE)

This matches the ID in SheetA-A2 to the same ID in SheetB in columnA, then returns the value 4 columns over. Pull that formula down and it will fill in answers for the other matching IDs. Adjust the column ranges if they need to widen or rows lengthen.

Now, use the same formula in the next column, just change the 4 to the column position that holds the next piece of data.

When you're done bringing data over with VLOOKUP formulas, highlight all the new data and do a Copy, Edit > PasteSpecial > Values to make the data permanent.