VLOOKUP with time
I am trying to do a VLOOKUP from a cell (A2) containing a time displayed as text (previously extracted from text), into a table containing values entered as time format.
I always get a message telling me that it couldn't find the value. I assume that it is trying to compare a text value with a time value, therefore not finding a match.
How do I tell the VLOOKUP function that the value in (A2) should be considered as TIME to match what's in the table ?
Thanks