I have a 3 columns of data:

INFORMATION | TYPE | MATCH
Jim Firstname
Jack Firstname
Tom Firstname
Jones Lastname
Smith Lastname
Davis Lastname

I have a list of data I need to enter into the MATCH column. I would like a
function in the MATCH column that automatically matches the data I enter in
the MATCH column with matching data in the INFORMATION column.

For example, if I enter the following data into the MATCH column

Jack
Smith
Davis

The MATCH column function matches MATCH column data and INFORMATION column
data:

INFORMATION | TYPE | MATCH
Jim Firstname
Jack Firstname Jack
Tom Firstname
Jones Lastname
Smith Lastname Smith
Davis Lastname Davis


I would really appreciate help with this

Thanks - G