Are you sure that column A is also in time format, and not text values
that happen to look like times?

Another problem might be that you have seconds in column A that are
not showing, but these will prevent an exact match.

As your table appears to be in ascending order, you might consider
doing a lookup with the fourth parameter set to TRUE (or omit it),
which will then match on the largest value less than the lookup_value.

Hope this helps.

Pete


On Feb 27, 1:45*pm, Kathl wrote:
hi,

my problem is that the vlookup function doesn't work using the following
tables-

lookup_value is a time format, like 16:25 (assuming here to be in D1)
table_array looks like this
* A * * * * * * * * * *B
16:25 * CN-CCTV-TV
16:40 * DK-TV2-TV
16:40 * NO-TV2-TV
17:00 * HK-PCCW-TV
17:05 * AU-SBS-TV
17:05 * RU-NTV+-TV
17:20 * JP-WOW-TV
17:25 * SE-TV4-TV
17:40 * CZ-PRMA-TV
17:40 * IE-RTE-TV
22:30 * CZ-PRMA-TV

In comparing the times I want to get the information in column B.
I implemented VLOOKUP(D1, $A$1:$B$11, 2, FALSE).

Isn't it possible to compare times? How could I solve it?