Why doesnt my filter work!!!!!

  • Thread starter Thread starter law
  • Start date Start date
L

law

I have a validation list Jan to Dec in cell D8.
Cell F8 has the following formula:
=IF(D8="","",VLOOKUP(D8,list!G:H,2,FALSE))
cell G8 has the following formula:
=IF(F8="","",VLOOKUP(F8,list!H:I,2,FALSE))
On sheet called List I have the following
col G has the months Jan to Dec
col H has the begining date of each month
col I has the end date of each month.

My problem is that whenever I select November (and only November) I get the
end date as 2 Dec 07. All the rest works great.
What is the problem here!!!!!!!......Help!
law
 
Replace these by
IF(D8="","",VLOOKUP(D8,list!G1:I12,2,FALSE))
IF(D8="","",VLOOKUP(D8,list!G1:I12,3,FALSE))
Just fix G1:I12 to match your situation
best wishes
 
Iv just realized why its not working. Further up the list I have another
entry with 1st November and its taking that one.
Thanks for the reply anyway.
 

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

#VALUE problem 4
dates of month automation 3
Date Lookup 8
Add and subract Time 1
Find the position of a date 6
Formula for Latest Entry For Each Month 4
Seeding in Drop Down List 3
Help with Excel Sum Function 3

Back
Top