I see I will have many hours studying Excel Hero in my future. I have used Evaluate ([]) very little, but it appears I will want to better understand its full scope due to the constant usage in the example; I think I now have a grasp on 
[offset(output,1,1,1,1)]
and I never thought of using a statement such as 
If Len(rZip) Then
!

If y'all are still out there and following, would you be so kind as to explain why in the following code they use "With Target.Parent.Hyperlinks"? Maybe I'm missing the boat, for I see nowhere that a hyperlink is used (stop laughing...)-
Private Sub Worksheet_Change(ByVal Target As Range)
    
    Dim sState As String
    
    If Target.Cells.Count > 1 Then Exit Sub                     'Only one cell selected
    If Intersect(Target, [MyList]) Is Nothing Then Exit Sub     'Cell is inside the evaluation area
    If Target = vbNullString Then                               'Cell has information
        If Intersect(Target, [MyList[Zip]]) Is Nothing Then     'Cell is in the Zip column of evaluation area
            Exit Sub
        End If
    End If
    
    With Target.Parent.Hyperlinks
        Select Case False
            Case Intersect(Target, [MyList[Zip]]) Is Nothing
                If Target = vbNullString Then
                    sState = vbNullString
                    Intersect(Target.EntireRow, [MyList[City]]) = vbNullString
                Else
                    ZipCodeFilter Target
                    sState = [offset(output,1,2,1,1)]
                    If [counta(offset(output,1,1,2,1))] = 1 Then
                        With Intersect(Target.EntireRow, [MyList[City]])
                            .Value = [offset(output,1,1,1,1)]
                        End With
                    Else
                        Intersect(Target.EntireRow, [MyList[City]]) = vbNullString
                    End If
                End If
                Intersect(Target.EntireRow, [MyList[State]]) = sState
            Case Else
        
        End Select
    End With
    
End Sub
Much learning from the example going on, and I am sure there will be a lot going through the site's blog!...

I know I am imposing on your time; if and when you can respond I appreciate it-