Creating a formula from the results of another formula

[sapapd]

D=July E=August F=September G=October H=November I=December

I have this formula: =SUM(D9,G9,I9)/3 in cell R9

In cell T9 I need a formula which states: If R9=D9, July, , If R9=G9, October, , If R9=I9, December, , (the extra space and comma are there purposely so I do not have to use Concatenate)

The result would be July, October, December



Any assistance would be greatly appreciated.

 

[Special-K99]

Explain in words what youre trying to achieve.

 

[Legacy 421546]

This is easily accomplished with VBA and a Case statement. Is D9, G9 and I9 the only cells that should be checked?

 

[sapapd]

I need a formula which looks at another formula to determine if the information equals what is requested, and if it does, enter the requested information.

Example: If the formula in cell R6 equals "D" enter the month which corresponds with the column "D", and If the formula in cell R6 equals "E" enter the month which corresponds with the column "E", etc.

I can get the formula to return the first qualifying month, however I am having trouble with the formula returning the other months that match the remaining formula from the 3 Month Average total.



[TABLE="class: grid, width: 1537"]
<tbody>[TR]
[TD="align: center"][/TD]
[TD="align: center"]D[/TD]
[TD="align: center"]E[/TD]
[TD="align: center"]F[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]H[/TD]
[TD="align: center"]I[/TD]
[TD="align: center"]J[/TD]
[TD="align: center"]K[/TD]
[TD="align: center"]L[/TD]
[TD="align: center"]M[/TD]
[TD="align: center"]N[/TD]
[TD="align: center"]O[/TD]
[TD="align: center"]P[/TD]
[TD="align: center"]Q[/TD]
[TD="align: center"]R[/TD]
[TD="align: center"]S[/TD]
[TD="align: center"]T[/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD="align: center"]JULY[/TD]
[TD="align: center"]AUGUST[/TD]
[TD="align: center"]SEPTEMBER[/TD]
[TD="align: center"]OCTOBER[/TD]
[TD="align: center"]NOVEMBER[/TD]
[TD="align: center"]DECEMBER[/TD]
[TD="align: center"]JANUARY[/TD]
[TD="align: center"]FEBRUARY[/TD]
[TD="align: center"]MARCH[/TD]
[TD="align: center"]APRIL[/TD]
[TD="align: center"]MAY[/TD]
[TD="align: center"]JUNE[/TD]
[TD="align: center"]TOTAL[/TD]
[TD="align: center"]Total / 12[/TD]
[TD="align: center"]3 Month Average[/TD]
[TD="align: center"]Annualized
Est. FY 17-18[/TD]
[TD]Projection formula

This is the formula I am trying to reach
formula =Month which corresponds to formula of column and row from "3 month Average total"[/TD]
[/TR]
[TR]
[TD="align: center"]6[/TD]
[TD="align: center"]41[/TD]
[TD="align: center"]13,590[/TD]
[TD="align: center"]6,857[/TD]
[TD="align: center"]45[/TD]
[TD="align: center"]6,744[/TD]
[TD="align: center"]7,843[/TD]
[TD="align: center"]13,628[/TD]
[TD="align: center"](24)[/TD]
[TD="align: center"]6,810[/TD]
[TD="align: center"]7,017[/TD]
[TD="align: center"]7,306[/TD]
[TD="align: center"]14,212[/TD]
[TD="align: center"]84,069[/TD]
[TD="align: center"]7,006[/TD]
[TD="align: center"]7,044
(formula) =SUM(L6,M6,N6)/3 [/TD]
[TD="align: center"]84,531 [/TD]
[TD="align: center"]3 month average times 12
March, April, May[/TD]
[/TR]
</tbody>[/TABLE]

 

[sapapd]

I would rather not have to use VBA (since I am not too familiar with the inter-workings of it), and no, it would include checking columns D-O with the corresponding row. Thanks.