| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup 1st column time 2nd column text
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Referencing date column A & time column B to get info from column | Excel Discussion (Misc queries) | |||
| Return text in Column A if Column B and Column K match | Excel Worksheet Functions | |||
| Text to Columns - Way to remove all column breaks at one time? | Excel Discussion (Misc queries) | |||
| Template to convert column of text to time | Excel Worksheet Functions | |||
| Pivot Table (vlookup 2 column text values, return 1 value) | Excel Discussion (Misc queries) | |||
Threaded Mode
