Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 385
Default 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!
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 107
Default 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!



  #3   Report Post  
Posted to microsoft.public.excel.misc
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!

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I combine spreadsheets and documents in one file? Trish Excel Discussion (Misc queries) 3 November 9th 06 10:17 PM
Combine information about products from 2 spreadsheets wstaylor81 Excel Worksheet Functions 1 December 15th 05 01:38 AM
Combine two spreadsheets with Different column headings Angela Excel Discussion (Misc queries) 5 December 8th 05 11:25 PM
Combine several spreadsheets for an emailmerge (perhaps using Acce Mike C. Excel Worksheet Functions 1 July 20th 05 05:06 PM
Combine two spreadsheets using Macro jlogsdon Excel Worksheet Functions 0 May 23rd 05 11:14 PM


All times are GMT +1. The time now is 11:36 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"