I am trying to create an imbeded if statement that will only look up a value
if it falls within a specific date range. So far I have been unseccessful.
it looks something like this:

If(and(D3=A$3$,D3=<B$3$),lookup(AA$1$,AB$3:AX$3$, ),"")

Any other ideas?

Thank you for the help