Subtotals or Vlookups or Both.

Hi All  I would be grateful if someone could help me to find a solution   am working on a sheet, such as  Period Name Narrative GBP 201902 Jane Doe Cakes  1.00 201806 Jane Doe ...