By the sounds of your problem you should definitely be able to use vlookup, but it's dependant upon the structure of sheet 2.

But using the same principles as with your previous vlookup where you used the shop code to bring back the contract type, you need to use the contract type to bring back the subjective codes.

But as NBVC says, if you post a dummy workbook you'll get a much clearer and more accurate response.