I need to create a reference link to use Excel to produce a quotation
calculator. I want a column of Product codes, a colum of cost prices and an
option on margins to be made then a sum at the end. I want to make a sheet
take data from other sheets within the same workbook with dropdown options
i.e. You choose "Product A" from a dropdown list and automatically the cost
price of Product A appears in column B...there is a dropdown menu on column C
offering 15%, 20%, 25% etc. and this will automatically calculate a "Sale
Price" in column D.

Is this possible?

in column B, use

=VLOOKUP(A2,product_table,2,False)

and sale price as

=b2*(1+c2)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Caseshopcom" wrote in message
...
I need to create a reference link to use Excel to produce a quotation
calculator. I want a column of Product codes, a colum of cost prices and
an
option on margins to be made then a sum at the end. I want to make a
sheet
take data from other sheets within the same workbook with dropdown options
i.e. You choose "Product A" from a dropdown list and automatically the
cost
price of Product A appears in column B...there is a dropdown menu on
column C
offering 15%, 20%, 25% etc. and this will automatically calculate a "Sale
Price" in column D.

Is this possible?