| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drop Down List were Text = numeric values for formulas
I created a drop down list with text. When I do a formula for another cell I
would like the text to represent a number. Help Help -- Thank You Lumberman |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Drop Down List were Text = numeric values for formulas
You should find your answer he
http://www.youtube.com/watch?v=Ko68R...eature=related HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "lumberman" wrote: I created a drop down list with text. When I do a formula for another cell I would like the text to represent a number. Help Help -- Thank You Lumberman |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Drop Down List were Text = numeric values for formulas
Simple example.
=LOOKUP(B1,{"A","B","C","D"},{1,2,3,4}) Gord Dibben MS Excel MVP On Mon, 3 Aug 2009 12:28:12 -0700, lumberman wrote: I created a drop down list with text. When I do a formula for another cell I would like the text to represent a number. Help Help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Validation List - Dependant based on numeric values | Excel Discussion (Misc queries) | |||
| Text into Numeric values? | Excel Discussion (Misc queries) | |||
| drop down list and adding numeric values to text | Excel Discussion (Misc queries) | |||
| Assigning numeric value to text in drop-down menu | Excel Programming | |||
| Using Numeric Values from Formulas | Excel Discussion (Misc queries) | |||
Linear Mode
