M
MF88
What EXCEL formula can I use for the following:
Cell E4 has Nov-09 (11/1/09 shows as Nov-09) currently. when I change this
to Dec 09, I want the number $39,403.25 (from a different worksheet) to
appear in E11.
Currently E11 has $85,904.50 from the corresponding month on the separate
worksheet (values listed below).
The month dates below and data are from a separate worksheet.
Jul-09 $0.00
Aug-09 $11,945.00
Sep-09 $11,043.01
Oct-09 $12,880.00
Nov-09 $85,904.50
Dec-09 $39,403.25
Cell E4 has Nov-09 (11/1/09 shows as Nov-09) currently. when I change this
to Dec 09, I want the number $39,403.25 (from a different worksheet) to
appear in E11.
Currently E11 has $85,904.50 from the corresponding month on the separate
worksheet (values listed below).
The month dates below and data are from a separate worksheet.
Jul-09 $0.00
Aug-09 $11,945.00
Sep-09 $11,043.01
Oct-09 $12,880.00
Nov-09 $85,904.50
Dec-09 $39,403.25