| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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! |
|
#2
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Excel Changing Numbers Automatically | Excel Discussion (Misc queries) | |||
| How do i update hyperlink in excel spread sheet automatically. | Excel Discussion (Misc queries) | |||
| Can you automatically insert next sequential number in an excel fo | Excel Discussion (Misc queries) | |||
| In Excel how can a number automatically display in text form | Excel Worksheet Functions | |||
Linear Mode
