Multiple Data Validations continued...

  • Thread starter Thread starter lunker55
  • Start date Start date
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
 
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
 
Back
Top