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
Bookmarks