I'm thinking that it will need perhaps some variation of one of the
below formulas:

=hyperlink(concatenate("b12785,Q12785))

=hyperlink (B12785,Q12785)

But I haven't got it to work yet.


--
johnnstacy
------------------------------------------------------------------------
johnnstacy's Profile: http://www.excelforum.com/member.php...o&userid=27302
View this thread: http://www.excelforum.com/showthread...hreadid=541294