Forum Discussion
VLOOKUP only matches "AM" time values. It does not match "PM" time values.
I have a single column with a list of sorted (ascending) time values (ie 3:00 AM, 3:00PM, so on) - called Milestones. I have another table called TimeTable with the entire time period (12 AM-11 PM) l...
Melanie, VLOOKUP doesn't care how the time or any other values formatted and it definetelly works with time values, but in internal format. Same 03:00AM could present 0.125 for the first day, 1.125 for the second, etc. VLOOKUP mutches the latest. Try to format your time values as decimal numbers and check shall they match or not.