+ Reply to Thread
Results 1 to 4 of 4

Common problem combining multiple sheets?

  1. #1
    Registered User
    Join Date
    07-30-2009
    Location
    Brisbane Australia
    MS-Off Ver
    Excel 2007
    Posts
    7

    Common problem combining multiple sheets?

    I'm fairly new to excel and completely new to the forum. I have a problem that surely must be a quite common one, but I've been searching high and low without finding what I'm after.

    I have two spreadsheets.

    Sheet 1 has two columns:

    Date Incidents
    02/11/06 200
    02/18/06 360
    02/24/06 240

    Sheet 2 has two columns too:

    Date Cost
    02/11/06 436
    02/12/06 229
    02/13/06 610
    02/14/06 374
    02/15/06 450
    02/16/06 56
    02/17/06 450
    02/18/06 450
    02/19/06 436
    02/20/06 450
    02/21/06 341
    02/22/06 654
    02/23/06 782
    02/24/06 336
    02/25/06 742
    02/26/06 582

    I want to combine the two to get:
    Date Cost Incidents
    02/11/06 436 200
    02/12/06 229
    02/13/06 610
    02/14/06 374
    02/15/06 450
    02/16/06 56
    02/17/06 450
    02/18/06 450 360
    02/19/06 436
    02/20/06 450
    02/21/06 341
    02/22/06 654
    02/23/06 782
    02/24/06 336 240
    02/25/06 742
    02/26/06 582

    I'd be very grateful for any help. And when giving your answer keep in mind that I'm a bit of an excel newbie Thanks!

  2. #2
    Forum Contributor
    Join Date
    08-13-2008
    Location
    South Africa
    Posts
    130

    Re: Common problem combining multiple sheets?

    You have the dates in two sheets, which date do you want to use? Can you attach a sample workbook?

  3. #3
    Registered User
    Join Date
    07-30-2009
    Location
    Brisbane Australia
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Common problem combining multiple sheets?

    Thanks for your quick reply! I want to use the dates from spreadsheet 2. Note that all dates in the date column of sheet 1 are already present in sheet 2. Sheet 2 has one row for every day in its interval.

  4. #4
    Registered User
    Join Date
    07-30-2009
    Location
    Brisbane Australia
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Common problem combining multiple sheets?

    Solved using match and replace.
    =INDEX(B:B;MATCH(A2;B:B;0))
    =INDEX(C:C;MATCH(A2;B:B;0))

    If anyone needs help with similar problem check out http://www.youtube.com/watch?v=59c60PWsZjI and/or pm me.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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