looking up names in seperate excel lists

I work in HR and I frequently have to cross reference lists with names of Employees. Often the names are written in a different order from list to list i.e. List A: First name[space]Family name  the...