View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David David is offline
external usenet poster
 
Posts: 1,560
Default vlookup(date, range,3)

Hello Group,

I am doing a vlookup on a date, I will take the closest date, so have not
used the last parameter. It returns the last date in the list always. Both
the date in the Lookup and in the table are type = 1, a number.

Am I missing something here or is it not possible to do this?

Thanks,
David