vlookup error?

[grichey]

I have the following formula:
=('2008 Budget'!VLOOKUP($D$4,E100:F111,2,FALSE)11)

D4 is a month. E100:F111 is a 2 column table
JAN A
FEB B
MAR C
.
.
.
What should happen is if JAN is entered in D4, the cell w/ the formula will show the value in wksheet 2008 Budget cell A11.

I keep getting the generic your formula contains an error.
Ideas?

[Bob Phillips]

=VLOOKUP($D$4,'2008 Budget'!E100:F111,2,FALSE)

[grichey]

This would just change the range of the table for the lookup. So let's say if I directly ref a cell it would ='2008 Budget'!B11. To use the table, I'd want the B to switch to C and so forth so the lookup would be only changing the B.

[Macha10]

to keep the range of the cell fix the vlookup table's references with $$

=VLOOKUP($D$4,'2008 Budget'!$E$100:$F$111,2,FALSE)