If statement problem
 

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="MAY 07",APR07!G$14,IF($D$5="JUN07",MAY07!G$14,"No
Data")))),"",IF($D$5="APR07",MAR07!G14,IF($D$5="MA Y07",APR07!G$14,IF($D$5="JUN07",MAY07!G$14,"No Data"))))

If statement problem
 

VLOOKUP
--
David Biddulph

"Scott@CW" wrote in message
...
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="MAY 07",APR07!G$14,IF($D$5="JUN07",MAY07!G$14,"No
Data")))),"",IF($D$5="APR07",MAR07!G14,IF($D$5="MA Y07",APR07!G$14,IF($D$5="JUN07",MAY07!G$14,"No
Data"))))

If statement problem
 

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(DATEVAL UE(D5))-1,1),"mmmyy")&"!G14"))

Rick


"Scott@CW" wrote in message
...
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="MAY 07",APR07!G$14,IF($D$5="JUN07",MAY07!G$14,"No
Data")))),"",IF($D$5="APR07",MAR07!G14,IF($D$5="MA Y07",APR07!G$14,IF($D$5="JUN07",MAY07!G$14,"No
Data"))))