I am making a parts invoice. It will list "Parts" and I would like the price
of the part to be linked to the specific part itself. I have a couple of
worksheets open, and they reference my drop-downs and prices etc, including
our discount and our total price. I need to link the product type to the
specific price for that product type. How do I do this?

See if this helps:

http://contextures.com/xlFunctions02.html

--
Biff
Microsoft Excel MVP


"Leanne" wrote in message
...
I am making a parts invoice. It will list "Parts" and I would like the
price
of the part to be linked to the specific part itself. I have a couple of
worksheets open, and they reference my drop-downs and prices etc,
including
our discount and our total price. I need to link the product type to the
specific price for that product type. How do I do this?