Insert a new row 1, so that all those cells you describe are now on
row 2. Put the names of the months in row1, so that F1 contains
January, G1 contains February etc. Then in F2 you can use this
formula:

=IF($A2=F$1,$E2,"n/a")

You can change the "n/a" to zero if you wish (may be better if you
want to do any arithmetic on the range). Then you can copy the formula
across to the December column.

PS. I didn't understand how your formula related to your description.

Hope this helps.

Pete

On Feb 18, 2:16*am, Kathleen
wrote:
Hi, *I have cell A1 with a drop down box containing 26 available choices. *B1
has the dollar amount matching to the choice in A1 using vlookup. *E1 totals
several cells including B1 together. *I want F1 to look at A1 and either
enter the number from E1 or NA. *Here's billing example:

A1=January , B1=$5 ,C1=$10, D1=$1, E1=$16 *(total of b-d1) *
F1 is the column for January
G1 is the column for February
H1 is the column for March, etc

If A1 = Jan, then F1 should be $16
If A1 = Feb, then F1 should be NA or $0

This is the formula that has been working so far:
=IF((G2="ONE (1)"),S2,IF((G2="TWO (2)"),S2,IF((G2="THREE
(3)"),S2,IF((G2="FOUR (4)"),S2,IF((G2="FIVE (5)"),S2,IF((G2="SIX
(6)"),S2,IF((G2="SEVEN (7)"),S2,IF((G2="EIGHT (8)"),S2,IF((G2="NINE
(9)"),S2,"NA"))))))))

I've maxed the nesting formula...is there any other way?