S
Scott@CW
I am using the below formula. I am trying to get to were when the cell says
"please select ....", I get "No Data" returned instead of "0". Please help!
=CHOOSE(MATCH($D$5,{"Select reporting Month
","JAN07","FEB07","MAR07","APR07","MAY07","JUN07","JUL07","AUG07","SEP07","OCT07","NOV07","DEC07"},0),JAN07!$F$14,JAN07!E$15,FEB07!E$15,MAR07!E$15,APR07!E$15,MAY07!E$15,JUN07!E$15,JUL07!E$15,AUG07!E$15,SEP07!E$15,OCT07!E$15,NOV07!E$15,DEC07!E$15)
Thank you
"please select ....", I get "No Data" returned instead of "0". Please help!
=CHOOSE(MATCH($D$5,{"Select reporting Month
","JAN07","FEB07","MAR07","APR07","MAY07","JUN07","JUL07","AUG07","SEP07","OCT07","NOV07","DEC07"},0),JAN07!$F$14,JAN07!E$15,FEB07!E$15,MAR07!E$15,APR07!E$15,MAY07!E$15,JUN07!E$15,JUL07!E$15,AUG07!E$15,SEP07!E$15,OCT07!E$15,NOV07!E$15,DEC07!E$15)
Thank you