+ Reply to Thread
Results 1 to 4 of 4

Data from two sheets, same product codes, match into a new sheet

  1. #1
    Registered User
    Join Date
    08-08-2014
    Location
    Chicago, IL
    MS-Off Ver
    2013
    Posts
    2

    Data from two sheets, same product codes, match into a new sheet

    I have 1 sheet of data for shipping results. One sheet has data from ground freight, and the other sheet has data from air freight. I am trying to set up a third sheet comparing all of the data (that's for later), by matching the products codes. Both sheets have the same product codes, and I want the new sheet to have a column for "Ground Code" and a column for "Air Code". Both of these columns will have the same codes because they are the same products. There are 5,000+codes to match for January alone, so is there a formula I can do?

  2. #2
    Valued Forum Contributor Hawkeye16's Avatar
    Join Date
    02-27-2013
    Location
    Holland
    MS-Off Ver
    ├ē┤ Pew Pew
    Posts
    441

    Re: Data from two sheets, same product codes, match into a new sheet

    If you could post a small example with the data layout that is used as well as an expected result we won't have to guess at what you want to see.
    Despite the high cost of living, it remains very popular.

    Don't forget to mark threads SOLVED when you get an answer and rep all the geniouses that helped you today!

  3. #3
    Registered User
    Join Date
    08-08-2014
    Location
    Chicago, IL
    MS-Off Ver
    2013
    Posts
    2

    Re: Data from two sheets, same product codes, match into a new sheet

    I unfortunately can't upload a sample, so I will try to be more specific.

    Sheet 1 and 2: Column A has Product Code. Column 2 in both sheets have shipping times, Column 3 has $ / Million, etc...

    Sheet 3 (this is what I want it to have): Column 1 has sheet 1 product code, column 2 has product code from sheet 2. Column 3 has ship time from sheet 1, column 4 has ship time from column 4, column 5 has $/million from Sheet 1, column 6 has $/million from sheet 2, etc...

    Does this make sense? Sorry that I can't upload a small sample.

  4. #4
    Valued Forum Contributor Hawkeye16's Avatar
    Join Date
    02-27-2013
    Location
    Holland
    MS-Off Ver
    ├ē┤ Pew Pew
    Posts
    441

    Re: Data from two sheets, same product codes, match into a new sheet

    If the product codes are the same like you said you should just list the product codes in column A. This should return the relevant info.

    Column B =iferror(Index('Sheet 1'!B:B,match(A1,'Sheet 1'!A:A,0)),"")
    Column C =iferror(Index('Sheet 2'!B:B,match(A1,'Sheet 2'!A:A,0)),"")
    Column D =iferror(Index('Sheet 1'!C:C,match(A1,'Sheet 1'!A:A,0)),"")
    Column E =iferror(Index('Sheet 2'!C:C,match(A1,'Sheet 2'!A:A,0)),"")

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] How to compare 2 sheets data on a single sheet through VBA Codes?
    By PRADEEPB270 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 10-10-2013, 04:13 AM
  2. match data 2 sheets. if match, then copy data from one sheet to another
    By flunzy in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 10-09-2013, 06:38 AM
  3. Replies: 0
    Last Post: 10-01-2012, 02:57 PM
  4. [SOLVED] Summing product sales from 2 different sheets that do not match row for row
    By rwab in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-10-2008, 02:12 PM
  5. [SOLVED] Getting product name from other sheet to match
    By NTaylor in forum Excel General
    Replies: 0
    Last Post: 12-15-2005, 03:10 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1