Excel - can one value be automatically substituted for another?

[Guest]

I want to be able to enter a price in one cell and have the discounted price
appear in the next cell (as if by magic) - the discount varies so can't be
expressed as a percentage or formula. Presumably I'd have to set up a
referral table somewhere that would import the data - but where, ond how...
and when!

 

[Anne Troy]

Exactly. In the example at the links, you can have the VLOOKUP return the
price and/or the discount price.
Tutorial:
http://www.officearticles.com/tutorials/order_form_or_invoice_form_in_microsoft_excel.htm
VLOOKUP:
http://www.officearticles.com/excel/vlookup_formulas_in_microsoft_excel.htm
************
Anne Troy
www.OfficeArticles.com