Hi Can anyone help me with this please.

I've been on it all morning and am stuck.

This is my formula

=IF($G$7=DATEVALUE("Apr-10"),Budget!$B2, IF($G$7=DATEVALUE("May-10"),Budget!$C2,

and so on for 12 months...

The problem is that when I hit 7, I am up to the limit for nested if statements.

Any ideas, I cant figure out VLOOKUP

I have found spliting the formula and giving the 2 parts defined name doesnt work as when I add them together again, I end up with only half the forumla working (as my lookup G7 will only be true on 1 half of the split formula.....

Hope someone can help

Thanks