Appreciate it if anyone can solve my problem. I am using Nested IF statements
to pull out data based on the month of the year:

=IF(BAE_Summary!$B$1="Jan",BAE_ActSpent!E8,IF(BAE_ Summary!$B$1="Feb",
BAE_ActSpent!F8,IF(BAE_Summary!$B$1="Mar", BAE_ActSpent!G8,
IF(BAE_Summary!$B$1="Apr", BAE_ActSpent!H8,IF(BAE_Summary!$B$1="May",
BAE_ActSpent!I8,IF(BAE_Summary!$B$1="Jun", BAE_ActSpent!J8,FALSE))))))

=IF(BAE_Summary!$B$1="Jul",BAE_ActSpent!K8,IF(BAE_ Summary!$B$1="Aug",
BAE_ActSpent!L8,IF(BAE_Summary!$B$1="Sep", BAE_ActSpent!M8,
IF(BAE_Summary!$B$1="Oct", BAE_ActSpent!B8,IF(BAE_Summary!$B$1="Nov",
BAE_ActSpent!C8,IF(BAE_Summary!$B$1="Dec", BAE_ActSpent!D,FALSE))))))

Everything seems to work fine until I get to January. #NAME$ shows up and I
cannot figure out what is wrong. Has anyone ever ran into this situation?
Appreciate any help I can get on this problem

--
Django