Presuming the data in cols B and C are sorted in ascending order by col B,
think you could try: =VLOOKUP(A1,B:C,2)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---
"-Julie" wrote:
I need help creating a formula, please. If column a contains today() and
column b contains dates and column c contains a number, I want the formula to
look at today's date and find the date closest but not higher than today and
return the corresponding number. In this case, I want an answer of "2"
returned.
A B C
1 06/11/2009 05/15/2009 1
2 05/31/2009 2
3 06/15/2009 3