Data Validation

[Guest]

I have 4 columns and i have a drop down list in One column with 4 options but
i would like if they change the option that the next four columns change to
that option they chose? ex. If i have Concrete In column C and they choose
Concrete out of the 4 options i want to values in Column D, Column E, and
Column F all in the same row to change to the value that equals Concrete?
Anyone can help?

 

[Guest]

You will need DATA VALIDATION and a VLOOKUP formula.
As you did not give me details, I'll give a formula then adjust it
accordinly to your columns and needs :
COPY IN C then paste it in D,E,F
=VLOOKUP($C1,SHEET2!$C1:F100,COLUMNS($C),O

 

[Guest]

Sorry, COPY FORMULA IN D and paste it in E , F ( Because your data
validation is in C).