Match/Lookup with multiple conditions

  • Hello,

    I have two time series, 1 in columns A,B,C and the other in columns D,E,F. Due to missing data in the first time series I need to match the values in column C for the date and time values in columns D and E. Below I have included an image of the raw data and a second image of what I hope to accomplish.

    Kind regards

  • Re: Match/Lookup with multiple conditions

    This is an array formula for cell G2

    enter the formula and Press Ctrl + Shift + Enter then copy it down


    it will put curly { } brackets around it.

    If you don't want an array you can use


    normal formula

    There are three types of people in this world.
    Those who can count and those who can't.