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?