Drop Down List were Text = numeric values for formulas

[lumberman]

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

 

[ryguy7272]

You should find your answer here:

HTH,
Ryan---

 

[Gord Dibben]

Simple example.

=LOOKUP(B1,{"A","B","C","D"},{1,2,3,4})


Gord Dibben MS Excel MVP