Excel - can one value be automatically substituted for another?
 

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!

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/tutori...soft_excel.htm
VLOOKUP:
http://www.officearticles.com/excel/...soft_excel.htm
************
Anne Troy
www.OfficeArticles.com

"RobBoddy" wrote in message
...
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!