Multiple Data Validations continued...

[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

 

[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