Desiree50
02-18-2011, 10:54 AM
I am need assistance with an if statment combining a date and a vlookup.
This is the formula and the dates are always the same. I need the dates to be able to get the correct information out of my database.
Suggestions?
IF(ISNA(VLOOKUP($B$7&$A11&F11&DATE(2010,1,1)>=$C$11),DATE(2010,1,7<=D11),'[Database Design.xlsx]Weekly Totals'!$K$3:$R$25000,8,FALSE)),0,VLOOKUP($B$7&$A11&F11&DATE(2010,1,1)>=C11,DATE(2010,1,7<=D11),'[Database Design.xlsx]Weekly Totals'!$K$3:$R$25000,8,FALSE))
This is the formula and the dates are always the same. I need the dates to be able to get the correct information out of my database.
Suggestions?
IF(ISNA(VLOOKUP($B$7&$A11&F11&DATE(2010,1,1)>=$C$11),DATE(2010,1,7<=D11),'[Database Design.xlsx]Weekly Totals'!$K$3:$R$25000,8,FALSE)),0,VLOOKUP($B$7&$A11&F11&DATE(2010,1,1)>=C11,DATE(2010,1,7<=D11),'[Database Design.xlsx]Weekly Totals'!$K$3:$R$25000,8,FALSE))