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) listed by the hour. I match the two tables using VLOOKUP and outputs the time if there is a match. It works only for the time listed as "AM" in the Milestones Table. Do you know why?
1 Reply
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.
