On the "General Comments" sheet I have created a series of codes which match a general comment.

I want to type these codes onto the "Student" sheet, under the ID column. What I want excel to do is match these codes to the corresponding "General Comment". This prevents copious amounts of retyping OR copying and pasting.

Is there a lookup function that can match a code and return text in the adjacent cell?

Comment Bank 1.xlsx