Welcome guest. Before posting on our computer help forum, you must register. Click here it's easy and free.

Author Topic: Excel lookup/index/reference problem  (Read 2485 times)

0 Members and 1 Guest are viewing this topic.

Space_Cowboy1

    Topic Starter


    Newbie

    • Experience: Experienced
    • OS: Windows 10
    Excel lookup/index/reference problem
    « on: October 11, 2017, 03:02:16 PM »
    Please see attached screenshot of excel file.  Cells C8:G11 are formatted as date mm/dd/yy
    row 6 shows the number of forecasted days to end date. 

    here is the goal - I want to find the rightmost non-blank value in each row, then add the number of days in row 6 from the same column, and drop the result in column g of that row.

    So,  cell g8 should say 10/17/17 because it adds the value of 6 (from c6) to the date in c8
    cell g9 should say 10/18/17 because it adds the value of 3 (from d6) to the date in d9
    cell g10 should say 10/23/17 because it adds the value 2 (from f6) to the date in e10

    and, oh yeah, one more thing....  If I add a value to the right of an existing date, I want the forecasted end date to recalculate - so, given the sample data, if I add 10/14/17 to cell d8, I want cell g8 to now reflect 10/14/17 plus 3 (from cell d6) -- and deposit 10/17/17 in cell g8.

    Your time and help are appreciated!

                         


    [attachment deleted by admin to conserve space]

    Mark.



      Adviser
    • Forum Regular
    • Thanked: 67
      • Yes
    • Certifications: List
    • Computer: Specs
    • Experience: Experienced
    • OS: Windows 10
    Re: Excel lookup/index/reference problem
    « Reply #1 on: October 15, 2017, 03:00:36 PM »
    how's your VBA knowledge?