Good Afternoon Rudi (its still morning here, just)


My column A, say A10=D5&E5, so my NAME (A10) = Firstname&Lastname.

On sheet 2 the cell that contains the name that is in sheet1(A5) is =Sheet1'!$A10.

So, sNAME gets populated correctly, but, iCol does not find the Name in sNAME it would see =Sheet1'!$A10

I don't know IF it will complicate things further, but, both NAMES in column A sheet1 and =Sheet1'!$A10 are hyperlinks too each other.

Kind regards,
Keith