All about Microsofy Excel FUNCTION
 

How to make it auto fill-in the value(column C2) to column between column F2 to column K2 whitch is matching column E2 with between F1 to K1 :-

C2 - 3000

E2 - JULY (WHITCH I KEY IN)

F1 - JULY
G1 - AUGUST
H1 - SEPTEMBER
I1 - OCTOBER
J1 - NOVEMBER
K1 - DECEMBER

If i key in JULY at column E2, so the value(C2) will auto fill-in to column F2 whitch is matching E2 & F1, by the same time, when i key in SEPTEMBER at column E2, the value of C2 will auto fill-in to column H2.
thanks for help
Daniel Law