|re: "but I have no idea how to make it compare the value in the second column with the row that was found."|
Here are some tips that might help you add the instruction that you need:
When the .Find method is used, the variable that is Set contains all of the properties of the value that was found. In other words - in your case - VBA knows what Row lastName is in, what Column it is in, what its font settings are, etc.
Any valid property can be returned with the following syntax:
lastName.Value (the default)
Therefore, you can use lastName.Row as a argument in other instructions, e.g.
If Sheets(3).Range("B" & lastname.Row) = Sheets(1).Range("AP" & lastName.Row) Then
If Sheets(3).Cells(lastname.Row, "B") = Sheets(1).Cells(lastName.Row, "AP") Then
If Sheets(3).Cells(lastname.Row, 2) = Sheets(1).Cells(lastName.Row, 42) Then
I hope that helps!
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.