Combining two worksheets

[farzyness]

Hello all,

I am looking to combine two worksheets with different data that have fields in common. Basically, I have a master worksheet with every single UPC and the costs attached to them for all the products that we carry, and another worksheet with select UPCs for a customer and the prices at which we sell those items at.

I want to make a spreadsheet where I can have all the costs attached to the customer's worksheet, basically pulling the costs from the master list and attaching them to the respective UPC.

Let me know if I need to be more clear. Any help would be great. Thanks!

[JBeaucaire]

You can use a VLOOKUP() formula to lookup a UPC in the current workbook, go to a second workbook to lookup an associated value in a database. Like so:

=VLOOKUP(A1, '[PriceSheet.xls]Sheet1'!$A$1:$B$10000, 2, 0)


This formula will look at a list of UPCs in column A of the PriceSheet.xls on Sheet1, then bring back the value that matches from column B.

[farzyness]

You can use a VLOOKUP() formula to lookup a UPC in the current workbook, go to a second workbook to lookup an associated value in a database. Like so:

=VLOOKUP(A1, '[PriceSheet.xls]Sheet1'!$A$1:$B$10000, 2, 0)


This formula will look at a list of UPCs in column A of the PriceSheet.xls on Sheet1, then bring back the value that matches from column B.

Thank you so much for your great help!!!

[JBeaucaire]

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.