Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I combine spreadsheets and documents in one file? | Excel Discussion (Misc queries) | |||
Combine information about products from 2 spreadsheets | Excel Worksheet Functions | |||
Combine two spreadsheets with Different column headings | Excel Discussion (Misc queries) | |||
Combine several spreadsheets for an emailmerge (perhaps using Acce | Excel Worksheet Functions | |||
Combine two spreadsheets using Macro | Excel Worksheet Functions |