Do I need IF function? Is there another way?

[CRM1512]

I'm setting up a basic spreadsheet for tracking employees and what the qualifications they are in the process of undertaking. I want to be able to type under the column titled "Qualification" the qualification they are doing (e.g. Certificate III Business Administration, Certificate III Signage, Certificate II Horticulture etc) and in the column beside it titled "QualCode" for the code to automatically appear (so, for Business BSB30407, for Signage CPC32108 and for Horticulture RTF20103).

I have no idea how to make the code appear when the Title is entered!

I have about 25 qualifications (and therefore, 25 qualification codes) so I'm not sure if this is an IF function?

Any help would be greatly appreciated. Please note, I'm a HR person, not an IT person! So apologies for my ignorance!

THANKS AGAIN