Index/Match formula possible change

[fdebelo]

Good Morning,
A little question with a formula

=INDEX(R38:W38,MATCH(FALSE,ISBLANK(R38:W38),0))

all the cells from R:38 to w:38 are blank, the formula is in x-38
The formula is working fine, and returns a value of #N/A due to all criteria being blank
Can I have the formula return another verbiage like "$0.00" instead of the #N/A?

[Fluff13]

How about
=IFERROR(INDEX(R38:W38,MATCH(FALSE,ISBLANK(R38:W38),0)),0)

[wk9128]

Just for 2003 version
=IF(ISERROR(INDEX(R38:W38,MATCH(FALSE,ISBLANK(R38:W38),0))),"",INDEX(R38:W38,MATCH(FALSE,ISBLANK(R38:W38),0)))

[fdebelo]

Great, thank you.