Combining Data

[AzDonny]

I have 2 worksheets. Work sheet A has 5000 line items along with pricing. Worksheet B has 900 Line Items without pricing. Worksheet B is my new inventory and I want to put pricing from Worksheet A into column C on worksheet B. Is there a function that can go to column A on worksheet B, and match that part number to column A on worksheet A and transfer the pricing from column C on Worksheet A to Column C on worksheet B. I can email a sample of these 2 files if that helps. I hope there is a way do do this so I dont have to manually transfer the list. Thanks - Don

[darkyam]

=VLOOKUP(A1,WorksheetA!$A$1:$B$5000,2,False) and drag down. This assumes WorksheetA consists of just two columns; you'll have to adjust the range and third argument as necessary.