Match date in cell to the same date in a range and return value from cell below

  • Hi Folks


    I'm trying to match the dates in C7 and D7 with the dates on the Data sheet and return the data below the correct dates into C8 and D8 on the attached example but not having much luck. I've tried using INDEX and MATCH but keep getting #VALUE error


    I'd really appreciate some help if at all possible please.


    Return_on_Dates.xlsx


    Kind regards


    Deryn

  • In order for you to extract the data you wish, you need to have your data in unique columns. You currently have data and dates in the same columns and mixed with the rows. You will need to either normalize your data or write some advanced VBA. Personally, I would prefer to see the data in the form of


    Title--Date--Amount--Change


    Four columns then allow for lots of analysis including Pivot Tables, Look ups, summarizations, etc.

  • Hi Alan


    Very good point, thank you.. I'll rearrange the layout and try again.


    Much appreciated..


    Deryn