HYPERLINK/CELL/MATCH/ISERROR not working

[JamesonMH]

Hi folks,

Trying to do a simple hyperlink so I can link to the first error value in the range.

Formula is {HYPERLINK("#"&CELL("address",MATCH(TRUE,ISERROR(range),0)))}

I keep getting the "we found a problem with this formula..." pop up. Seems to be the "#"&CELL("address"... portion, which otherwise works fine with many of my other formulas.

Thanks,
James

 

[Yongle]

This works for me
Enter as an array formula with CTRL+SHIFT+ENTER

=HYPERLINK("#"&ADDRESS(MATCH(TRUE,ISERROR($B$1:$B$10),0),2))

 

[JamesonMH]

Thanks Yongle - that works for me when I use your ADDRESS formula, as opposed to CELL.