=VLOOKUP(TODAY(),Region!$A:$S,5,FALSE)

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

I have this formula to look up a date in column A and then display
what is in E.

=VLOOKUP(TODAY(),Region!$A:$S,5,FALSE)

Works fine if I only have one field for that date.

Column A = Date
Column B = Time

How do I get it to display the most recent value in column E? if I
have 2 date the same in column A
 
Is your data sorted or grouped together so that all dates/times are in a
contiguous range:

6/8/2009...10:00 AM
6/8/2009...10:45 AM
6/8/2009...12:00 PM
 
Back
Top