ISERROR array problem

[reggie1000]

hello,

I have the following array formula

Please Login or Register  to view this content.

when i try to include an IF(ISERROR at the start it errors at the underlined "INDIRECT"

Please Login or Register  to view this content.

any ideas anyone????

thanks reg

[martesoft]

My guess is that you have too many nested functions within that formula, so you need to break it down. You really need to do that anyway.