Hi I have a spreadsheet which contains data, in simplified form as
A Name B Ref
Another spreadsheet which has only name
I need to get the reference which matches the name on both sheets into a new
column. Which is the best way of doing this?
Many thanks--
Denise