Hi, new to Excel and need help with a formula! First page is an order form,
second is the data base containing products and prices. I'd like to know the
formula that enables me to link product 1,on sheet2, to its adjacent price in
sheet 2, then have it calculate the total price on sheet 1. Example: Sheet2
(products linked to drop down list on sheet 1) when product 1 is selected
from the drop down list on sheet1, the price of that product is inserted into
the sub total box on the same page and then adds subsiquent sellection from
other drop down lists to the same sub total. If anyone is willing to help I
could send a copy of the file for you to avaluate.
Thank you in advance!