I want to enter a name and have the address automatically in

[Guest]

I want to enter customer invoice numbers and have the names,addresses,phone number,ect put into there respective cells in the worksheet. I did it before but have forgoten how to do it could you please help.
Bill Martin
Edinburgh

 

[Barrie Davidson]

On 2002-03-09 08:02, Anonymous wrote:
I want to enter customer invoice numbers and have the names,addresses,phone number,ect put into there respective cells in the worksheet. I did it before but have forgoten how to do it could you please help.
Bill Martin
Edinburgh

Bill, use a VLOOKUP function to grab your customer's information. For an explanation of VLOOKUP see

http://ca.geocities.com/b_davidso/Web_Page_Files/Excel/lookup.html#VLOOK

Regards,