Forum Discussion
asmoore
Aug 15, 2025Copper Contributor
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 ...
SergeiBaklan
Aug 16, 2025Diamond Contributor
=VLOOKUP(A2*1, $H$2:$I$6, 2, 1)
shall work