Vlookup codes based type of contract

Hello,

First timer here

I have been trying to figure how to change the finance subjective codes based upon the type of contract it is.

The three types are AMS, MGS and CDL

On my spread sheet there are 40 different types of shops that are all either AMS,MGS,CDL and had a unque all begining C**** code for each shop. So far I have been able to vlookup on the sheet if I put in a shop code it will recognise the type of contract it is. What I want to do is then pull off from another sheet the subjective codes that are specific to that contract e.g AMS office expenses H2334,Rent H3456,PAYE,h6754. So that if I put a shop that is MGS the subjective codes will change like office expenses X6543,Rent R4567,PAYE 4567

The three seperate contract subjective codes are all on sheet 2 called LC

How would I go about this? is vlookup the correct funtion?

any help is much appreciated

thanks

S