LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 14
Default Vlookup using 2 criteria

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Vlookup with 4 Criteria Gina_28 Excel Discussion (Misc queries) 4 October 15th 08 12:45 AM
vlookup 2 criteria Lost in Microbiology Excel Discussion (Misc queries) 10 January 9th 08 09:47 PM
Vlookup with more than 1 criteria EoinL Excel Discussion (Misc queries) 2 October 11th 07 12:08 PM
VLOOKUP or IF with many criteria Alys Excel Worksheet Functions 2 April 17th 07 01:26 PM
VLOOKUP with MAX criteria tralls Excel Discussion (Misc queries) 2 October 26th 05 12:12 AM


All times are GMT +1. The time now is 11:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"