PDA

View Full Version : Excel/vlookup if statement confusion



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

Bob Phillips
02-18-2011, 12:15 PM
That formula makes no sense, the VLOOKUP is incomplete.

What exactly are you trying to do?

Desiree50
02-18-2011, 12:18 PM
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.