=HYPERLINK((CONCATENATE(C5,HLOOKUP(C3,master!
R1:AP4,2,FALSE))),"PRESS TO SELECT")

This revision of the above worked fine over he
=HYPERLINK("#"&CELL("address",INDIRECT(C5&HLOOKUP( C3,Master!R1:AP4,2,FALSE))),"PRESS TO SELECT")
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Larry" wrote:
I am trying to use a hyperlink to go to a named range depending upon the
values of two cells concatenated together. Here is what have.
=HYPERLINK((CONCATENATE(C5,HLOOKUP(C3,master!R1:AP 4,2,FALSE))),"PRESS TO
SELECT") The lookup is necessary because of varying values. This returns
the proper named range but when I click on it it says "Cannot open specified
file".