| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I attach a number to a cell with text to use in a formula?
I am trying to make a spreadsheet to allow for pricing. I have a dropdown box
in a cell with stock codes and I want to attach a cost to each code so I only have to click on the code for it to be included in a formula. How can I have the formula read a number(cost) from a text(stock code) cell? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Attach a Help Text With A UDF! | Excel Discussion (Misc queries) | |||
| Excel Formula, text & number in cell | Excel Discussion (Misc queries) | |||
| number and text in cell for formula | Excel Worksheet Functions | |||
| extract number and use in formula from text & numbers in cell | Excel Worksheet Functions | |||
| attach a label to number, like validation but follows the number | Excel Worksheet Functions | |||
Threaded Mode
