How do I combine spreadsheets?

[Guest]

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!

 

[Andy Wiggins]

This sounds like a job for VLOOKUP.

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

 

[Guest]

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