grichey
02-01-2008, 08:09 AM
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?
=('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?