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.
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.