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.

D

E

F

G

H

I

J

K

L

M

N

O

P

Q

R

S

T

5

JULY

AUGUST

SEPTEMBER

OCTOBER

NOVEMBER

DECEMBER

JANUARY

FEBRUARY

MARCH

APRIL

MAY

JUNE

TOTAL

Total / 12

3 Month Average

Annualized Est. FY 17-18

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"

6

41

13,590

6,857

45

6,744

7,843

13,628

(24)

6,810

7,017

7,306

14,212

84,069

7,006

7,044 (formula) =SUM(L6,M6,N6)/3

84,531

3 month average times 12 March, April, May

<tbody>
</tbody>

 

[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.