Dylan has shown deep understanding of how environments. He is able to accurately use the conventions of mapping.

In Comments, column A produces a unique identifier such as SOSE_B

I use the values in H6 and I6 to build this identifier to be looked up in Comments column A
H6: SOSE
I6: B
H6&"_"&I6 produces SOSE_B

vlookup looks that value up in the sheet comments in column A. The 4 as the 3rd argument of Vlookup says to return the value from the 4th column of the Lookup range in the same row as a match is found for the lookup value. In this case, the match is made in row 2 and the comment you showed is returned. This returned string is processed by the second Substitute function to replace the case sensitive string {Name} with the name in F6. This adjusted returned string is processed by the first Substitute function and it replaces the case sensitive substring "{HE}" with the results of the if function =if(G6="Male","He","She")

so the final returned value is as I show.

So you would just need to build your comments sheet to contain the values you want similar to what I have shown. You would have each row in that sheet identified by the unique combination of Subject and Grade.

--
Regards,
Tom Ogilvy

Questioner's Rating

Rating(1-10)

Knowledgeability = 10

Clarity of Response = 10

Politeness = 10

Comment

Mate you are an absolute legend!
Very well explained and easy to do.
That is going to make things so much easier for me.
Thanks so much!!

About Excel
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here

Expertise

Selected as an Excel MVP by Microsoft since 1999. Answering Excel questions in Allexperts since its inception in 2001. Able to answer questions on almost all aspects of Excel's internal capabilities. If seeking a VBA solution, please specify that in your question itself so I give you the answer you want.
[Excel has weak protection - if you are distributing an application, I don't answer questions on how to protect your project from your users.]