Results 1 to 4 of 4

Matching one dates column with another and returning a value

Threaded View

Rookie100 Matching one dates column... 01-04-2012, 12:56 AM
teylyn Re: Matching one dates column... 01-04-2012, 01:26 AM
Rookie100 Re: Matching one dates column... 01-04-2012, 01:36 AM
Ryan Murtagh Re: Matching one dates column... 01-04-2012, 01:42 AM
  1. #1
    Registered User
    Join Date
    12-26-2011
    Location
    UK
    MS-Off Ver
    Excel 2000
    Posts
    6

    Matching one dates column with another and returning a value

    Column A:A contains chronological dates.
    Column B:B contains values pertaining to column A:A.
    Column C:C contains recurring dates.

    I'd like the values of column B placed in column D next to the corresponding C column dates.

    A B C D
    19/08/2000 £100.00 19/08/2000 £100
    20/08/2000 £102.45 19/08/2000
    21/08/2000 £107.45 19/08/2000
    22/08/2000 £107.45 19/08/2000
    23/08/2000 £112.60 19/08/2000
    24/08/2000 £112.60 19/08/2000
    25/08/2000 £112.60 19/08/2000
    26/08/2000 £112.60 20/08/2000
    27/08/2000 £112.60 20/08/2000

    So the formula for cells D1:D7 would return £100.
    Then the formula for cells D8:D9 would return £102.45.
    ... and so on.

    Any input welcome.

    Apologies for the lack of format. Not really that good with the forum yet, and had trouble posting the excel file.

    I think it pretty easy to gather what my aim is anyhow.

    Thanks for viewing.
    Last edited by Rookie100; 01-04-2012 at 01:43 AM. Reason: [SOLVED]

Thread Information

Users Browsing this Thread

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

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