Return a specified date when it falls within a range....

  • Thread starter Thread starter Nokose451
  • Start date Start date
N

Nokose451

Hello all. I hope someone can help me figure this one out. So here we
go....

I have a spread sheet that you plug in a date and then enter another
date manually. The second date is the on I would like to automate. I
need the first date to be complared in a range of dates and then return
the effective date.

Example:
Entered date - 01/08/2006

Range Table: Effective:
01/01/2006 - 01/05/2006 01/05/2006
01/06/2006 - 01/10/2006 01/10/2006
01/11/2006 - 01/15/2006 01/15/2006

I would like it to return the 01/10/2006 effective date for that range.
Any help is appreciated.
 
Use VLOOKUP:


If your data is in cols A,B,C and the target is in F1 then
=VLOOKUP(F1,A1:C3,3,TRUE) will return the desired value.
 

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

How to get individual dates from a date range 3
LOOKUP within a 1
LOOKUP function between two dates in Excel 2007 6
Insert ' sign infront of dates 5
Excel not recognizing dates as dates 1
COUNT BETWEEN A SPECIFIC DATE RANGE 4
Dates Milestones 6
VBA to populate workdat between dates 2

Back
Top