Help with if and vlookup

[cmkayak]

I am having problems getting the correct lookup value based on the date with the following forumula:

=if)c7>=10/1/2011,(vlookup(d8,fy2012drgwts,2)),(vlookup(d8,fy2011drgwts,2)))

If I enter a date < 10/1/2011 I get the fy2012drgts instead of fy2011drgwts. What am I doing wrong?

 

[Trouttrap2]

try this
=IF(C7 >= DATE(2011,10,1),VLOOKUP(D8,fy2012drgwts,2),(VLOOKUP(D8,fy2011drgwts,2)))

 

[Domenic]

Excel reads 10/1/2011 as 10 divided by 1 divided by 2011, which equates to 0.00497265. Therefore, try entering the date value as follows...

"10/1/2011"+0

or

DATE(2011,10,1)

 

[cmkayak]

It worked. Thanks!

 

[T. Valko]

I am having problems getting the correct lookup value based on the date with the following forumula:

=if)c7>=10/1/2011,(vlookup(d8,fy2012drgwts,2)),(vlookup(d8,fy2011drgwts,2)))

If I enter a date < 10/1/2011 I get the fy2012drgts instead of fy2011drgwts. What am I doing wrong?

Use a cell to hold the date:

A1 = 10/1/2011

Then:

=IF(C7>=A1,VLOOKUP(D8,fy2012drgwts,2),VLOOKUP(D8,fy2011drgwts,2))