R
Rob
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
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