LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 186
Default vlookup with Dates

I have a column of dates that i what to do a lookup on. The column looks
like the following:

01/01/08 5
02/01/08 6
03/01/08 7


I what to find the value in column two for the date 2/15/08. If i put False
in the vlookup formula i get 5 as the answer, if i put True i get 7 as the
answer. How do i get the answer from the row with 2/01/08.

 
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 on Dates LossManiac Excel Worksheet Functions 6 August 29th 08 02:25 PM
vlookup using dates MH Excel Discussion (Misc queries) 2 May 28th 07 05:53 PM
vlookup and dates! KneeDown2Up Excel Worksheet Functions 6 April 2nd 07 08:44 AM
dates and vlookup grapes Excel Worksheet Functions 1 February 2nd 06 09:19 PM
VLookUp with Dates o1darcie1o Excel Worksheet Functions 4 September 2nd 05 01:18 PM


All times are GMT +1. The time now is 11:35 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"