software

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=quot;Janquot;,BAE_ActSpent!E8,IF(BAE_ Summary!$B$1=quot;Febquot;,
BAE_ActSpent!F8,IF(BAE_Summary!$B$1=quot;Marquot;, BAE_ActSpent!G8,
IF(BAE_Summary!$B$1=quot;Aprquot;, BAE_ActSpent!H8,IF(BAE_Summary!$B$1=quot;Mayquot;,
BAE_ActSpent!I8,IF(BAE_Summary!$B$1=quot;Junquot;, BAE_ActSpent!J8,FALSE))))))

=IF(BAE_Summary!$B$1=quot;Julquot;,BAE_ActSpent!K8,IF(BAE_ Summary!$B$1=quot;Augquot;,
BAE_ActSpent!L8,IF(BAE_Summary!$B$1=quot;Sepquot;, BAE_ActSpent!M8,
IF(BAE_Summary!$B$1=quot;Octquot;, BAE_ActSpent!B8,IF(BAE_Summary!$B$1=quot;Novquot;,
BAE_ActSpent!C8,IF(BAE_Summary!$B$1=quot;Decquot;, 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

How about a much simpler formula:
=OFFSET(BAE_ActSpent!A8,0,MATCH(BAE_Summary!B1,{quot;O ctquot;,quot;Novquot;,quot;Decquot;,quot;Janquot;,quot;Feb
quot;,quot;Marquot;,quot;Aprquot;,quot;Mayquot;,quot;Junquot;,quot;Julquot;,quot;Augquot;,quot;Sepquot;},0 ))
and could even be simpler if the months (beginning with Oct) were in a range
of cells, like A1:A12:
=OFFSET(BAE_ActSpent!A8,0,MATCH(BAE_Summary!B1,A1: A12,0))

Bob Umlas
Excel MVP

quot;Djangoquot; gt; wrote in message
...
gt; Appreciate it if anyone can solve my problem. I am using Nested IF
statements
gt; to pull out data based on the month of the year:
gt;
gt; =IF(BAE_Summary!$B$1=quot;Janquot;,BAE_ActSpent!E8,IF(BAE_ Summary!$B$1=quot;Febquot;,
gt; BAE_ActSpent!F8,IF(BAE_Summary!$B$1=quot;Marquot;, BAE_ActSpent!G8,
gt; IF(BAE_Summary!$B$1=quot;Aprquot;, BAE_ActSpent!H8,IF(BAE_Summary!$B$1=quot;Mayquot;,
gt; BAE_ActSpent!I8,IF(BAE_Summary!$B$1=quot;Junquot;, BAE_ActSpent!J8,FALSE))))))
gt;
gt; =IF(BAE_Summary!$B$1=quot;Julquot;,BAE_ActSpent!K8,IF(BAE_ Summary!$B$1=quot;Augquot;,
gt; BAE_ActSpent!L8,IF(BAE_Summary!$B$1=quot;Sepquot;, BAE_ActSpent!M8,
gt; IF(BAE_Summary!$B$1=quot;Octquot;, BAE_ActSpent!B8,IF(BAE_Summary!$B$1=quot;Novquot;,
gt; BAE_ActSpent!C8,IF(BAE_Summary!$B$1=quot;Decquot;, BAE_ActSpent!D,FALSE))))))
gt;
gt; Everything seems to work fine until I get to January. #NAME$ shows up and
I
gt; cannot figure out what is wrong. Has anyone ever ran into this situation?
gt; Appreciate any help I can get on this problem
gt;
gt; --
gt; Django
Bob thanks a lot. This was very educational.
--
Djangoquot;Bob Umlasquot; wrote:

gt; How about a much simpler formula:
gt; =OFFSET(BAE_ActSpent!A8,0,MATCH(BAE_Summary!B1,{quot;O ctquot;,quot;Novquot;,quot;Decquot;,quot;Janquot;,quot;Feb
gt; quot;,quot;Marquot;,quot;Aprquot;,quot;Mayquot;,quot;Junquot;,quot;Julquot;,quot;Augquot;,quot;Sepquot;},0 ))
gt; and could even be simpler if the months (beginning with Oct) were in a range
gt; of cells, like A1:A12:
gt; =OFFSET(BAE_ActSpent!A8,0,MATCH(BAE_Summary!B1,A1: A12,0))
gt;
gt; Bob Umlas
gt; Excel MVP
gt;
gt; quot;Djangoquot; gt; wrote in message
gt; ...
gt; gt; Appreciate it if anyone can solve my problem. I am using Nested IF
gt; statements
gt; gt; to pull out data based on the month of the year:
gt; gt;
gt; gt; =IF(BAE_Summary!$B$1=quot;Janquot;,BAE_ActSpent!E8,IF(BAE_ Summary!$B$1=quot;Febquot;,
gt; gt; BAE_ActSpent!F8,IF(BAE_Summary!$B$1=quot;Marquot;, BAE_ActSpent!G8,
gt; gt; IF(BAE_Summary!$B$1=quot;Aprquot;, BAE_ActSpent!H8,IF(BAE_Summary!$B$1=quot;Mayquot;,
gt; gt; BAE_ActSpent!I8,IF(BAE_Summary!$B$1=quot;Junquot;, BAE_ActSpent!J8,FALSE))))))
gt; gt;
gt; gt; =IF(BAE_Summary!$B$1=quot;Julquot;,BAE_ActSpent!K8,IF(BAE_ Summary!$B$1=quot;Augquot;,
gt; gt; BAE_ActSpent!L8,IF(BAE_Summary!$B$1=quot;Sepquot;, BAE_ActSpent!M8,
gt; gt; IF(BAE_Summary!$B$1=quot;Octquot;, BAE_ActSpent!B8,IF(BAE_Summary!$B$1=quot;Novquot;,
gt; gt; BAE_ActSpent!C8,IF(BAE_Summary!$B$1=quot;Decquot;, BAE_ActSpent!D,FALSE))))))
gt; gt;
gt; gt; Everything seems to work fine until I get to January. #NAME$ shows up and
gt; I
gt; gt; cannot figure out what is wrong. Has anyone ever ran into this situation?
gt; gt; Appreciate any help I can get on this problem
gt; gt;
gt; gt; --
gt; gt; Django
gt;
gt;
gt;