If statement problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to write the below formuls to include all twelve months, and of course
I can't do more than 7 if's. Anyone have any ideas?

=IF(ISERROR(IF($D$5="APR07",MAR07!G14,IF($D$5="MAY07",APR07!G$14,IF($D$5="JUN07",MAY07!G$14,"No
Data")))),"",IF($D$5="APR07",MAR07!G14,IF($D$5="MAY07",APR07!G$14,IF($D$5="JUN07",MAY07!G$14,"No Data"))))
 
If I understand your attempted formula correctly, I think you can use this
formula instead...

=IF(ISERROR(DATEVALUE(D5)),"No
Data",INDIRECT(TEXT(DATE(RIGHT(D5,2),MONTH(DATEVALUE(D5))-1,1),"mmmyy")&"!G14"))

Rick
 
Back
Top