iserror problem


G

Guest

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
 
Ad

Advertisements

D

Dave Peterson

What's in $d$5?

If it's really a date, maybe:

=choose(match(text($d$5,"mmmyy"), ......
 
Ad

Advertisements

G

Guest

D5 is a DV list of dates like this: JAN07, FEB07, etc. This is pulling from
other worksheets in the book.
 

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

Similar Threads

choose match formula 2
Formula Help 3
Formula Help 4
random start and calculation 3
If statement problem 2
Pivot Table 5
Access Chart with a secondary Y Axis 2
Problem with sum across worksheets 2

Top