Excel/vlookup if statement confusion

[Desiree50]

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))

[Bob Phillips]

That formula makes no sense, the VLOOKUP is incomplete.

What exactly are you trying to do?

[Desiree50]

I am trying to reference certain data to compare on a worksheet and a database. I will go back to drawing board. My other formulas work just fine it is when I add the date function it wont' work. I will see about working around it. Thanks for your help.