Populating a cell from a picklist selection

  • Thread starter Thread starter Phil Servedio
  • Start date Start date
P

Phil Servedio

In the spreadsheet example below, I need to populate
F2 with the numeric association of the selection from the
picklist. So, for example if Low is selected, F2=20, Med then
F2 gets 40 and so on.

A B C D E F G
1) Lo Med Hi VHi Huge
2) 20 40 60 80 100 [ ] Low
Med <-- Data Validation picklist
Hi
VHi

The question is, can a formula be built within the
data validation itself to populate F2? (I know that using a
HLookup within F2 can do it, but I also want to allow the user
to enter custom values).

Is a formula possible (using indirect, hlookup, offset, etc),
or do I have to use a VBA content change event?

-Phil
 

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

Need Filtered Pick List 5
Data validation list drop-down values based on prior selections 2
Prevent duplicate entries within a range of cells from a drop-down 3
populating cells using data from a different worksheet 4
Need a conditional drop-down list (list contents) 2
populate duplicate data into a spreadsheet 1
Performance tradeoffs of complex worksheet functions vs VBA? when to switch to a UDF? 4
Updating a cell from a list selection 1

Back
Top