Check out VLOOKUP in help.
I would assume you need an exact match, so check out the last argument,
"Range LookUp".

NickHK

"tecnicopc" wrote in message
ups.com...
Morning all,

I have been trying to get excel to automaticaly update cells from
another xls file but have been unable to do it, can you help?

I have an invoice.xls and an addressbook.xls, instead of copy/paste the
customer data cell by cell I would like to type the company name into
the correct cell on the invoice and have excel get the additional data
(address, tel, vat no# etc etc) from the address book file. this would
be a great tool for thousands and cant believe that it does not
allready exist. as it seems really simple with regards to some of the
great solutions already here, can anyone help?

many thanks in advance

Carl