Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vlookup help
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If (Vlookup 0) working, but what if Vlookup cell does not exist | Excel Worksheet Functions | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Which is faster: VLOOKUP-worksheet or VB-array VLOOKUP? | Excel Programming | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |