If statement problem

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"))))
 
R

Rick Rothstein \(MVP - VB\)

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top