Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am trying to use vlookup to populate a table with less data over the same
time period. I can use the data/time column (see below) but the date/time repeats sometimes for different values in the second column. So my question is how can i get vlookup to match the values in the first and second columns when it retrieves data for the column i am interested in... 7/1/2008 0:52 KBA 25.6 (column of interest) .. .. different time and date stamps... .. .. 7/1/2008 0:52 Kgg 30.6 When i use vlookup now to find the exact match it returns the first instance on that particular time stamp, how can i get it to match to that second column too. Many thanks!! Marcus |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Vlookup with 4 Criteria | Excel Discussion (Misc queries) | |||
vlookup 2 criteria | Excel Discussion (Misc queries) | |||
Vlookup with more than 1 criteria | Excel Discussion (Misc queries) | |||
VLOOKUP or IF with many criteria | Excel Worksheet Functions | |||
VLOOKUP with MAX criteria | Excel Discussion (Misc queries) |