Thread: Drop Down List were Text = numeric values for formulas
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default 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 With QuoteReply With Quote