Data validation, changing 2 cells at once

[exceldemon]

I have a data validation setup on Sheet 1 , lets call it "Material Description", cell A1. The list of material descriptions is in Sheet 2, A1 - A10. Also on Sheet 2 is a list of material numbers, B1 - B10. These numbers correspond to the descriptions.

Back to Sheet 1. I have a validation that looks at the "Material Description" nameset from Sheet 2. I am trying to have cell A2 change to match the material number that corresponds to whatever description is selected in A1.

Is this possible?

 

[grizz]

your data validation is in sheet2 A1:A10
in sheet 2 B1:B10 is your code #
A1 sheet1 is your drop down
in B1 put

[=VLOOKUP(A1,sheet2!A1:B10,2,FALSE)/PHP]