Prevent formula from returning #VALUE

[suprsnipes]

Hi,

How do I prevent the following formula from returning #VALUE?

=IF(ISNA(getaddress(INDEX(araw!$F$3:$F$1054,MATCH(1,(A2=araw!$A$3:$A$1054)*
("ter"=araw!$C$3:$C$1054),0)))),0,getaddress(INDEX(araw!$F$3:$F$1054,MATCH(1,(A2=araw!$A$3:$A$1054)*("ter"=araw!$C$3:$C$1054),0))))

suprsnipes

 

[T. Valko]

Hi,

How do I prevent the following formula from returning #VALUE?

=IF(ISNA(getaddress(INDEX(araw!$F$3:$F$1054,MATCH(1,(A2=araw!$A$3:$A$1054)*
("ter"=araw!$C$3:$C$1054),0)))),0,getaddress(INDEX(araw!$F$3:$F$1054,MATCH(1,(A2=araw!$A$3:$A$1054)*("ter"=araw!$C$3:$C$1054),0))))

suprsnipes

What kind of value does getaddress return?

What version of Excel are you using?

 

[suprsnipes]

Thanks for the reply.

getaddress is a UDF to get a hyperlinks address.

I'm using Excel 2000

 

[T. Valko]

Thanks for the reply.

getaddress is a UDF to get a hyperlinks address.

I'm using Excel 2000

OK try this...

Still arry entered.

=LOOKUP("zzzzz",CHOOSE({1,2},"",getaddress(INDEX(araw!$F$3:$F$1054,MATCH(1,IF(araw!$A$3:$A$1054=A1,IF(araw!$C$3:$C$1054="ter",1)),0)))))

That'll return a blank instead of an error.

 

[suprsnipes]

Brilliant, thanks alot!

 

[T. Valko]

Brilliant, thanks alot!

You're welcome. Thanks for the feedback!