Multiple Data Validations continued...

L

lunker55

Thanks Frank, but I have dozens of options. Is there any way besides using
VBA?

I have 4 Data Validation lists, 3 of which use the INDIRECT function. Once
the last list is chosen, I need a value entered automatically in the
adjacent cell.

ie: If cell E2="Standard Oak", then I need the number 5 in cell F2
If cell E2="Standard Maple", I need the number 6 in cell F2.

etc.

Any help would be appreciated.
joe
 
F

Frank Kabel

Hi Joe
frist please stay in the original thread - makes it easier to contionue
For multiple options you may use VLOOKUP. e.g. you have a separate
sheet (lets say 'conditions'):
A B
Standard Oak 2
Standard Maple 6
.....

the use the following formula in F2
=VLOOKUP(E2,'conditions'!$A$1:$B$30,2,0)

Frank
 

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

Multiple Data Validation lists 1
Changing the format of data in a cell 3
Dynamic Data validation Lists 1
Data Validation-Dependant Lists-Multiple 2
Using =IF(B10<>"",COUNTA($B$10:B10),"") to number rows in columns other than A 2
Formula for summing addresses within a single cell 1
Using VBA To Enter A Sumproduct Formula Into A Cell 0
data validation for a single text entry 8

Top