Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
iserror problem
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,APR 07!E$15,MAY07!E$15,JUN07!E$15,JUL07!E$15,AUG07!E$1 5,SEP07!E$15,OCT07!E$15,NOV07!E$15,DEC07!E$15) Thank you |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
iserror problem
What's in $d$5?
If it's really a date, maybe: =choose(match(text($d$5,"mmmyy"), ...... Scott@CW wrote: 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,APR 07!E$15,MAY07!E$15,JUN07!E$15,JUL07!E$15,AUG07!E$1 5,SEP07!E$15,OCT07!E$15,NOV07!E$15,DEC07!E$15) Thank you -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
iserror problem
D5 is a DV list of dates like this: JAN07, FEB07, etc. This is pulling from
other worksheets in the book. "Dave Peterson" wrote: What's in $d$5? If it's really a date, maybe: =choose(match(text($d$5,"mmmyy"), ...... Scott@CW wrote: 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,APR 07!E$15,MAY07!E$15,JUN07!E$15,JUL07!E$15,AUG07!E$1 5,SEP07!E$15,OCT07!E$15,NOV07!E$15,DEC07!E$15) Thank you -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ISERROR | Excel Worksheet Functions | |||
IF ISERROR | Excel Discussion (Misc queries) | |||
Iserror & VBA | Excel Discussion (Misc queries) | |||
iserror | Excel Worksheet Functions | |||
iserror | Excel Discussion (Misc queries) |