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

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
 
T

T. Valko

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VLOOKUP Problem in EXCEL 2010 3
Vlookup or similar 7
VBA Worksheet Event Change or Selection Question, please assist me 2
The code below worked for a few days and just totally stoppedworking. What can I do to make sure it 1
Formulas in Conditional Formula 5
VLOOKUP formula? 12
Vlookups using 2 Values 2
Looking for IF with VLOOKUP statement with two conditions. 6

Top