Can you sort each work sheet by part number. You cxan then use lookup function

in the worksheet you want the merge data havve it perform a lookup on the
other worksheets using the lookup function


where column c is the part numberand column F is the data you need

Add to sheet1
=lookup("Part Number",'sheet2'!C2:C1000,'sheet2'!F2:F1000)

"Neha" wrote:

I have 4 worksheets (different price lists) where the part number is a column
in all the sheets. I would like to merge the work sheets using the part
number as the common denominator and have all the rest of the columns merge
on that basis creating one large worksheet.
Thanks