Intersect Named Range And Column

I have a Worksheet Change event that when a cell (H5) is changed, it does a search for the value on another sheet. When it finds that value, I would like it to find the intersection of the column it found the value in and a named range.

Here is what I have so far. It works when I use the

Code:
.Range("H4") = c.Offset(15)
, but not the
Code:
.Range("S8") = isect.Offset(3)
.

Code:
Private Sub Worksheet_Change(ByVal Target As Range)
On Error Resume Next
UpperCase Target

'Fills in 60 Point form when part number is changed
'Sheets("60 POINT").Unprotect

[Code] ........