Indirect Data Validation with Auto Populate of Seperate Values

_{Request assistance with indirect data validation (error code) and auto populate of values based on indirect values. Please see attached spread sheet with subject generic example.}

In D1 metti:
=VLOOKUP(C1,'special auto pop codes'!A2:C27,2,0)

in E1
=VLOOKUP(C1,'special auto pop codes'!A2:C27,3,0)

SOLVED - Thank you very much; spreadsheet is uploaded with your resolution. Again, thank you!

Ok, please. hello to the next.