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.
    [ATTACH=CONFIG]42802[/ATTACH][ATTACH=CONFIG]42803[/ATTACH]


    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


    =INDEX($C$2:$C$100,MATCH(D2&E2,$A$2:$A$100&$B$2:$B$100,0))


    it will put curly { } brackets around it.


    If you don't want an array you can use


    =INDEX(C:C,SUMPRODUCT(($A$2:$A$100=D2)*($B$2:$B$100=E2)*ROW($A$2:$A$100)))


    normal formula

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