Fvschedule with non numeric or non blank cells

Hello Guys,

I used to know how to overcome this problem, but again I need your help
I'm running a year-to-date calculation using FVSCHEDULE formula and some of cells containing the future schedules are nonblank. Nonblank meaning that these cells refer to an INDEX(),MATCH(),MATCH(). Also, since I am using the following type of formula

=IF(ISERROR(INDEX(XXXXX,MATCH(XXXX),MATCH(XXXX)))=FALSE,INDEX(XXXXX,MATCH(XXXX),MATCH(XXXX)),"")

, when appropriate the formula will return

""

which is a blank cell in appearance, BUT apparently excel considers it as NONBLANK.

Bottom line, I'm getting a nice #VALUE!
I have the answer why I'm getting the #Value!:

The values in schedule can be numbers or blank cells; any other value produces the #VALUE! error value for FVSCHEDULE. Blank cells are taken as zeros (no interest).

source http://office.microsoft.com/en-us/ex...005209100.aspx

BUT I need the Solution!

Please don't hesitate to ask me more info.

Thank you guys