I have a list of last names and want to see if the last name appears in a list of other last names. I've tried multiple formulas and can't get anything to work. The issue is that the last name I am searching to see if is on the 2nd worksheet could be in cells A1, B1, or C1

This is how my spreadsheet is laid out
Worksheet 1

A B C D
A1 Company Name| B1 First Name| C1 Last Name| D1 (This is the cell I want to say Match if the last name is found in the other worksheet)



Worksheet 2
A B C
1 Name Name Name