How do I combine spreadsheets?
 

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!

How do I combine spreadsheets?
 

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!

How do I combine spreadsheets?
 

Well, since english is not my mother tongue, I have no idea of what SUK and
UPC may stand for. However, here's how you can solve your problem, I thing :

Let's assume that the 1st sheet looks like this:
UPC SUK
a aa
b bb
c cc

And that the 2nd sheet looks as follows:
UPC Matching SUK
a
a
b
a
c
d

In the "Matching SUK" column, just type in and copy along the following
formula :
=VLOOKUP(A2,Sheet1!$A$2:$B$4,2,FALSE)

The 2nd sheet should then show:
UPC Matching SUK
a aa
a aa
b bb
a aa
c cc
d #N/A

"Jennifer" wrote:

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!