Drop Down List were Text = numeric values for formulas

  • Thread starter Thread starter lumberman
  • Start date Start date
L

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
 
Simple example.

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


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Validation List (conditional) 2
Excel Excel: How do I put a formula in a drop down list 11
How to dynamically change the list in drop down list based on thevalue of another cell? 1
VBA drop down list help 3
Change cell value when selection made from drop list in another ce 3
Help with creating drop down 1
Macro to run based on drop down list 7
Pick from drop-down list gives empty or erroneous result 6

Back
Top