I need help trying to pull information within a start date and end date. The
order date should be between the start and end date and then pull the correct
discount that was applied at that time.
ex...
Record# Start Date End Date Disc
001 4/15/2006 4/15/2007 12.5
002 3/15/2005 4/14/2006 13.5
003 2/15/2004 4/13/2006 14.2

If the order date is 10/28/2005 then it should pull discount 13.5 because the
order date falls within that range.
I need to figure out how to program Excel to figure this out. I have 36,000
lines that I need to check against. Can anybody help me with this?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200704/1