Multiple Data Validation lists

  • Thread starter Thread starter lunker55
  • Start date Start date
L

lunker55

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
in F2 enter the following:
=IF(E2="Standard Oak",5,IF(E2="Standard Maple",6,""))

Frank
 
Back
Top