hi
i'm having problem with formula for date lookup on range between two
dates which are in two columns.

for example: Lookup Date in A1 11/23/05

lookup table
B1(begin.date) C1(end date) D1(return value)
10/20/05 11/21/05 Nov
11/22/05 12/17/05 Dec
11/23/05 1/30/06 Jan

i need to create a Excel formula (i dont want that function being in
VBA) which will return "Jan" from lookup table

would appreciate a help
cheers
Dim