Forum Discussion
VLOOKUP Not Working with Time Values
I'm trying to use VLOOKUP to return a time period name (i.e., "Morning," "Afternoon," "Night," etc.) for corresponding time values. The formula works when I manually type the time value as I did ...
Hello , your vlookup Formula is correct, check the Cell format of A column ( Start time) and Set to time format i.e HH:MM:SS AM PM.
Image for Reference
and then write formula
=VLOOKUP(A2,$H$1:$I$6,2,TRUE)
Thank