Trying, but to no avail

srcurrie · Mar 25th, 2002, 11:53 AM

I am trying to create a customer worksheet with an entire price sheet on 1st page and customer information on the 2nd page. I want to be able to get prices for a job using the price sheet on page 1 without really editing page 1 at all. I have posted before and I've been told to use LOOKUP or VLOOKUP, I am new to all of this and would like more info.

Basically what my pricesheet has is just 4 columns.
A Amount of Parts Needed
B Part Name
C Part Description
D Unit Price
E Extended Price

Any help would be greatly appreciated.

Barrie Davidson · Mar 25th, 2002, 12:02 PM

Have a look at:

http://ca.geocities.com/b_davidso/We...kup.html#VLOOK

Regards,

Tom Schreiner · Mar 25th, 2002, 07:11 PM

Hi
I have a standard database form I can edit a bit and send to you. It will allow you to type in a part description or just the first fe letters or numbers and will bring up the whole list with totals
Send me your E-Mail
tstom@hotmail.com
tom

Mar 25th, 2002, 12:02 PM	#2
Barrie Davidson MrExcel MVP Join Date: Feb 2002 Location: Winnipeg Posts: 2,330	Have a look at: http://ca.geocities.com/b_davidso/We...kup.html#VLOOK Regards, __________________ Barrie Davidson "You're only given a little spark of madness. You mustn't lose it." - Robin Williams

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

Mar 25th, 2002, 11:53 AM	#1
srcurrie New Member Join Date: Mar 2002 Posts: 18	I am trying to create a customer worksheet with an entire price sheet on 1st page and customer information on the 2nd page. I want to be able to get prices for a job using the price sheet on page 1 without really editing page 1 at all. I have posted before and I've been told to use LOOKUP or VLOOKUP, I am new to all of this and would like more info. Basically what my pricesheet has is just 4 columns. A Amount of Parts Needed B Part Name C Part Description D Unit Price E Extended Price Any help would be greatly appreciated.

Mar 25th, 2002, 07:11 PM	#3
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Hi I have a standard database form I can edit a bit and send to you. It will allow you to type in a part description or just the first fe letters or numbers and will bring up the whole list with totals Send me your E-Mail tstom@hotmail.com tom