Forum Discussion

Lei_Nacken's avatar
Lei_Nacken
Copper Contributor
Aug 29, 2020

vertical lookup

Hi,
I want to use vertical lookup on time values. 
I have a matrix with in the first Collum date and time and in the second Collum a value.
But the normal vert.lookup function does not work.
Is there a solution?


Tnx in advance

excel
Formulas and Functions

2 Replies

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Aug 29, 2020

    Lei_Nacken What exactly are you trying to lookup, and how? For instance, the date/time for "29/08/2020 15:46:11" is stored in Excel as the number 44072.6570717593000 The time portion alone, i.e. "15:46:11" equals the number 0.657071759259259.

     

    You may have to split the time and date column first, then round the time 10 digits in order to be able to lookup the time value only.