need help finding a Date range within long list

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Weeknum Within a Range 5
Use Text and Cell vale to reference a named range inside a formula 1
I NEED HELP 1
array formula(s)- not working, need some help please (problem with an 'AND') 7
hlookup value within a range 4
Please help with formula (multiple ifs to determine due date) 3
Date Range within a date range - try again 2
Date ranges 1

Back
Top