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

Mar 9th, 2002, 09:02 AM

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 · Mar 9th, 2002, 09:06 AM

Quote:

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/We...kup.html#VLOOK

Regards,

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 9th, 2002, 09:02 AM	#1
Guest Posts: n/a	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