samedi 6 février 2021

Is there something wrong with my Vlookup formula?

enter image description here

I have sheet1 which contains a list of player names and recorded time. In "C" column, a IF condition is used to determine if the player fails or passes the time requirement comparing the recorded time(in Sheet1) and the expected time (which is listed in Sheet2). In "D", I use the Vlookup to list out the expected timing for each player respectively and it seems to be working as it is supposedly to be. But in row 5, it gives a False result when it should be No as 10:00AM is more than the 6:00AM..

IF + Vlookup:

 =IF(B5>VLOOKUP(A5,Sheet2!$A$2:$B$4,2,0), "NO","OK")

Aucun commentaire:

Enregistrer un commentaire