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

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

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