| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking Text to a numerical value
Is there some way for me to type text in a cell, and that will generate a
price for that item inside another cell? This way I can just type my items in my materials column, and it will automatically populate in my price column. -- Thank you, Rick |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Linking Text to a numerical value
Sounds like a VLOOKUP job. See the help.
"RickE" wrote: Is there some way for me to type text in a cell, and that will generate a price for that item inside another cell? This way I can just type my items in my materials column, and it will automatically populate in my price column. -- Thank you, Rick |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Assigning numerical value to text | Excel Worksheet Functions | |||
| Numerical Value to text | New Users to Excel | |||
| text has numerical values | Excel Worksheet Functions | |||
| I want to check for a text value, not numerical | Excel Worksheet Functions | |||
| VLOOKUP first numerical value (not text) | Excel Worksheet Functions | |||
Linear Mode
