Why doesnt my filter work!!!!!
 

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

Why doesnt my filter work!!!!!
 

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
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

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

Why doesnt my filter work!!!!!
 

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.
--
law


"Bernard Liengme" wrote:

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
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

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