Anyone know how to use address lists in Excel?

[MrsThierryHenry]

I have inherited a contact list which was created in Excel. This week I have created an invoice also in Excel, and I now need to pull through the addresses from the database so that they appear automatically in the invoice.

Is there some way that I can do this? Or would it be better to just use a different application altogether?

Thanks!

I would create the document in word and use mail merge

Yessss...I can see this is going to create lots more work for me than I'd like...!

No, don't do it in word, excel is perfect for this, but it is much easier to do than explain.

Best explanation I can find in a hurry is here.

Or just search for 'match and index'.

Wow, thanks for that MrVibrating (hmm..interesting name)! I'll take a good hefty look at that.

xxx