I am trying to do a Vlookup using time. Whenever I reference the cell in the
formula that contains the time I want to look up, it converts the time into a
number (e.g. 8:40 a = .36111...) and will not look up properly in the array
table. I have formatted the lookup value as a time. Not sure what else to
do.
Thanks!
-CRM