Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
why doesnt auto recovery work? | Excel Discussion (Misc queries) | |||
COUNTIF doesnt work! | Excel Worksheet Functions | |||
why doesnt my RANDBETWEEN function work? | Excel Worksheet Functions | |||
sum totaling doesnt work | Excel Worksheet Functions | |||
Formula doesnt work | Excel Worksheet Functions |