Update the name with the code based on two criteria

Hello,

I am looking for a vlookup that looks at two criteria's and populates the code in cell C in the tab 'Input' based on the information shown in the site tab