need help finding a Date range within long list
 

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

What does not work? The dollar signs are wrong for the A3 but I assume that
is a typo
Are the date in D3 real numeric dates and not text (that goes for A3 and B3
as well)?
Does the LOOKUP function give expected results without the IF/AND function?

--
Regards,

Peo Sjoblom


"A shink" wrote in message
...
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

Thanks for the response.

Those are typos. The formula somewhat works. What happens is that the
formula pulls all data expcept for the end date. It includes all data not
just those dates that I am requesting(ie. Beginning date through end date).

Any other formulas you can think of or tricks jof the trade?

Thank you for the attention

"Peo Sjoblom" wrote:

What does not work? The dollar signs are wrong for the A3 but I assume that
is a typo
Are the date in D3 real numeric dates and not text (that goes for A3 and B3
as well)?
Does the LOOKUP function give expected results without the IF/AND function?

--
Regards,

Peo Sjoblom


"A shink" wrote in message
...
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