| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vlookup help - urgent
Hi all
I am trying to find a value in column 1 of table A, that is similar to value in column 1 of table B. I tried using VLOOKUP function( =vlookup(A1, B1:B20, true) but it is giving me repeated values. .. Consider the following A- col1 B-Col1 Result 5:39 AM 5:45 AM 5:39 AM 5:47 AM 5:50 AM 5:47 AM repeat 5:55 AM 5:55 AM 5:47 AM repeat 6:02 AM 6:00 AM 5:55 AM 6:09 AM 6:05 AM 6:02 AM 6:15 AM 6:10 AM 6:09 AM repeat 6:21 AM 6:15 AM 6:09 AM repeat 6:27 AM 6:20 AM 6:15 AM 6:33 AM 6:25 AM 6:21 AM 6:39 AM 6:30 AM 6:27 AM 6:44 AM 6:35 AM 6:33 AM 6:49 AM 6:40 AM 6:39 AM 6:54 AM 6:45 AM 6:44 AM 6:59 AM 6:50 AM 6:49 AM 7:04 AM 6:55 AM 6:54 AM 7:08 AM 7:00 AM 6:59 AM 7:13 AM 7:05 AM 7:04 AM 7:17 AM 7:10 AM 7:08 AM 7:21 AM 7:15 AM 7:13 AM Is it possible to remove the repeated value and consider the next higher value. Function or macro any help is appreciated. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
vlookup help - urgent
Please try:
=VLOOKUP(A6, B$5:B$23, 1,TRUE) the look up range remains constant and the value returned is from column B. 5:39 is less than 5:45 so a N/A value is returned as explained in help on this function. "sharmashanu" wrote: Hi all I am trying to find a value in column 1 of table A, that is similar to value in column 1 of table B. I tried using VLOOKUP function( =vlookup(A1, B1:B20, true) but it is giving me repeated values. .. Consider the following A- col1 B-Col1 Result 5:39 AM 5:45 AM 5:39 AM 5:47 AM 5:50 AM 5:47 AM repeat 5:55 AM 5:55 AM 5:47 AM repeat 6:02 AM 6:00 AM 5:55 AM 6:09 AM 6:05 AM 6:02 AM 6:15 AM 6:10 AM 6:09 AM repeat 6:21 AM 6:15 AM 6:09 AM repeat 6:27 AM 6:20 AM 6:15 AM 6:33 AM 6:25 AM 6:21 AM 6:39 AM 6:30 AM 6:27 AM 6:44 AM 6:35 AM 6:33 AM 6:49 AM 6:40 AM 6:39 AM 6:54 AM 6:45 AM 6:44 AM 6:59 AM 6:50 AM 6:49 AM 7:04 AM 6:55 AM 6:54 AM 7:08 AM 7:00 AM 6:59 AM 7:13 AM 7:05 AM 7:04 AM 7:17 AM 7:10 AM 7:08 AM 7:21 AM 7:15 AM 7:13 AM Is it possible to remove the repeated value and consider the next higher value. Function or macro any help is appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Urgent VLOOKUP HELP? Don't even know if this is what I need | Excel Worksheet Functions | |||
| Matching data from three columns (VLOOKUP, HLOOKUP, etc...)-URGENT | Excel Worksheet Functions | |||
| IME MODE FOR EXCEL 2007 (URGENT URGENT) | Excel Discussion (Misc queries) | |||
| URGENT ASSIST NEEDED IF POSSIBLE RE VLOOKUP/MATCH | Excel Programming | |||
| Urgent Dynamic Range with Vlookup | Excel Discussion (Misc queries) | |||
Linear Mode
