I have a spreadsheet with two columns of data - the index field and the actual data.

I want to open a Word document and be able to highlight some text, then run a macro which will pop over to Excel, look up the highlighted text in the index, copy the data cell, and insert it into the Word document.

I've tried doing this with the macro recorder but it doesn't work properly. Any help appreciated.

(So in my Excel sheet I have:
A1: "foo"
B1: "Data associated with foo."

In Word, I want to select "foo" and hit ctrl-whatever, and have "Data associated with foo." brought over.)