Merging Variable Info on Identical Data

[WillDoDat]

I have two worksheets with Serial Numbers and Bar Codes that tie the two together. I would like to combine them into one row based on the common data. The example below shows the process as it now stands. I brought the data into one worksheet and aligned the common data columns and then sorted. (Header Included)

ID Number 10-Jun-04 Serial. VABarCode. Building ROOM # Rtng# # Manufacturer Model # Asset Code Status CMR# Inventory Date Notes
12539766 101 308656 LAF 427 182 POLYCOM SOUNDSTATION TELE CONFERENCER 0 10 10/18/2001
Polycom Soundstation 209998 57 12539766 101 308656

The sort does not differenciate between whether the blank columns of the one worksheet resides above or below the common row of the other worksheet.

I appreciate any help on this issue.

 

[Andy B]

Hi

I would suggest uding VLOOKUP to bring the values from the other sheet. Have
a look at it in Help. It is quite a powerful function. It is difficult to
see from your data, but I'm guessing that you've posted a line from each
sheet - the common link being 12539766.
In the sheet that the second line came from you need a VLOOKUP on the common
number onto the first sheet, probably something like:
=VLOOKUP(D2,Sheet1!$A$2:$H$1000,2,FALSE)
This looks up the value in D2 (the common number) in the list A2:H1000 (or
whatever the range is) in Sheet1 and returns the data from the 2nd column
there. This formula then needs replicating across the range.
Hope this helps!
--
Andy.

I have two worksheets with Serial Numbers and Bar Codes that tie the two

together. I would like to combine them into one row based on the common
data. The example below shows the process as it now stands. I brought the
data into one worksheet and aligned the common data columns and then sorted.
(Header Included)

ID Number 10-Jun-04 Serial. VABarCode. Building ROOM # Rtng# #

Manufacturer Model # Asset Code Status CMR# Inventory Date Notes

12539766 101 308656 LAF 427 182 POLYCOM SOUNDSTATION TELE CONFERENCER 0 10 10/18/2001
Polycom Soundstation 209998 57 12539766 101 308656

The sort does not differenciate between whether the blank columns of the

one worksheet resides above or below the common row of the other worksheet.