View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Bernard Bernard is offline
external usenet poster
 
Posts: 30
Default 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!