Why doesnt my filter work!!!!!

[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

 

[Bernard Liengme]

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

 

[law]

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.