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:D),O


"Nick" wrote:

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?