Drop Down List were Text = numeric values for formulas

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
 
G

Gord Dibben

Simple example.

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


Gord Dibben MS Excel MVP
 

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
Macro to run based on drop down list 7
VBA drop down list help 3
Drop Down with hidden values 1
Drop Down List Format 2
linking the selection of a drop-down list to a quanity in another 2

Top