Multiple Data Validation lists

[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

 

[Frank Kabel]

Hi Joe
in F2 enter the following:
=IF(E2="Standard Oak",5,IF(E2="Standard Maple",6,""))

Frank