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!
|