is there a way to have i.e. a list of people's names in one column, and a
list of company regions in another column, so that whenever you click on a
person's name in the first column, Excel highlights that person's region in
the second column?

(so the user can find out any person's Region, by clicking on their name.)