Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

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

Posted on Jan 12, 2014 12:12 PM

Reply
7 replies

There are no replies.

VLOOKUP with time

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.