This sounds like a job for VLOOKUP.

Take a look in Excel's "Help" and see if this function will work for you.

--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-

"Jennifer" wrote in message
...
I have two spreadsheets I need to combine. One of them is just SKU and UPC
codes for a group of items. The other is UPC codes and new prices and
order
multiples for a larger group of items that includes those in the first
spreadsheet. I need to get the SKU numbers matched up to the
corresponding
UPC codes on the second sheet. How do I do this? Thanks for any help!