I have a Spreadsheet with two sheets.
Sheet 1 has the following data in columns
Forname Surname Birth Place Nationality
Alan Jones Liverpool
Allan Jones Cardiff
David Ellis Manchester
David Ellis Leeds
Clive Newman London
Sarah Roberts Cardiff

Sheet 2 has the following
Surname Forename Birthplace Nationality Forename Birthplace
Natioanlity
Jones Alan Liverpool English Allan
Cardiff Welsh
Ellis David Manchester English David
Leeds English

etc

How can I insert in sheet 1 the nationality where all three varialble must
match
i.e. Alan Jones Liverpool = Jones Alan Liverpool and returns the text
English in Sheet 1