I have two data sets in excel, each with the same unique id. I am trying to
enrich the data from one data set with the other. Therefore if for example I
have name and address details & the unique ID on one sheet AND I have say
annual spend and unique ID on another sheet. I want to combine the data sets
using the unique ID as the identifier and create one whole data set. ie. have
one data set with unique ID, name & Address and spend on one sheet

Can this be done?