Can someone help me with using address lists in Excel?

[Peddy]

Version: v.X
Operating System: Mac OS X 10.3 (Panther)
Processor: Power PC

I have inherited a contact list which was created in Excel. This week I have created an invoice 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!

 

[Bob Greenblatt]

Version: v.X
Operating System: Mac OS X 10.3 (Panther)
Processor: Power PC

I have inherited a contact list which was created in Excel. This week I have
created an invoice 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!

You can do this in Excel, but we'll need some more information in order to
help. Are the addresses and invoices separate workbooks? How is the address
list structured? Are named ranges used? Look in Help for HLOOKUP. If you
assume your addresses are a table, then hlookup should work fine.