+ Reply to Thread
Results 1 to 9 of 9

If date in column A matches reference date, display data 3,5 & 10 days after

Hybrid View

  1. #1
    Registered User
    Join Date
    03-07-2014
    Location
    nyc
    MS-Off Ver
    Excel 2003
    Posts
    3

    If date in column A matches reference date, display data 3,5 & 10 days after

    So, on attached spreadsheet I have a list of dates in col A, with price in B. In col G, I have specific dates. In H,I,J,K i have specific dates that I would like to see prices also. I have highlighted what I would like end result to look like.

    I would like to have the ability to enter different data in A.B & G and have it show 3,5, & 10 days after.

    thank you,
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    03-15-2013
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    36

    Re: If date in column A matches reference date, display data 3,5 & 10 days after

    Enter this into cell H3 and fill down:

    =INDEX($B$2:$B$121,(MATCH($G3,$A$2:$A$121,0)))

  3. #3
    Registered User
    Join Date
    03-15-2013
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    36

    Re: If date in column A matches reference date, display data 3,5 & 10 days after

    3.xls

    See attached. You can fill down as needed

  4. #4
    Registered User
    Join Date
    03-15-2013
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    36

    Re: If date in column A matches reference date, display data 3,5 & 10 days after

    Entire sheet completed

    4.xls

  5. #5
    Registered User
    Join Date
    03-15-2013
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    36

    Re: If date in column A matches reference date, display data 3,5 & 10 days after

    I reread your question and realized that I think you are looking for your heading to say PRICE 3 days after, etc. If that is the case then I have attached a file that will do this.

    Please note that you have several values that are guessing at the correct price because you have gaps and missing days. Let me know how else I can assist.

    5.xls

  6. #6
    Registered User
    Join Date
    03-07-2014
    Location
    nyc
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: If date in column A matches reference date, display data 3,5 & 10 days after

    Thanks Matt. Yea, thats the issue. There are gaps in the dates (holidays and weekends). I need to capture the price 3, 5 & 10 days after the date in col G. I appreciate your help, I'm working on it.

+ 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. reference column date (yesterday) to get Month(Date) for copy paste
    By jukabub in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-09-2013, 03:52 AM
  2. Replies: 3
    Last Post: 06-22-2013, 12:54 PM
  3. [SOLVED] Lookup Date 14 days prior and add multiple values for that date into column
    By Shylmysten in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-03-2013, 02:15 AM
  4. Replies: 2
    Last Post: 03-19-2010, 05:22 PM
  5. Replies: 3
    Last Post: 08-22-2006, 04:20 PM

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