Use Query, then Hyperlink

Not sure of your knowledge of VBA, but this thread (and the xref at the bottom) discusses how to do just that sort of thing.

My knowledge of VBA is none existance.

Where would I insert the following code in Excel? ray:

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
'Sub foo()
'Set Target = [E5].... End If
Set WS = Nothing
End If
End Sub

Thanks for helping.

Whewwy! This was a fun little feller for a Friday afternoon!

Okay - no VBA then...

Here's Sheet1:
Formula in B1 is:
=HYPERLINK(RIGHT(CELL("Filename",Sheet2!A1),LEN(CELL("Filename",Sheet2!A1))-FIND("[",CELL("Filename",Sheet2!A1),1)+1)&"!"&ADDRESS(MATCH(A1,Sheet2!A:A,0),1),A1)

Here's Sheet2:

Hi Greg,

What's wrong with the formula in Sheet B. The formula is Sheet A works fine, but Sheet B does not; even though it uses the same formula

Sheet A

Sheet B

My hunch is that you're getting some type of failure to Match(). For troubleshooting you can use Tools | Formula Auditing | Evaluate Formula to step through the formula and see which component is failing. Or you can build the formula up step-by-step to find the fault and then figure out how to fix the fault, i.e.
G2=MATCH(F2,PO!C:C,0)
G3=ADDRESS(MATCH(F3,PO!C:C,0),3)
...
and so forth.
Then twiddle with either formula components or inputs into the formula until it starts behaving itself.

HTH