RBC interview question

Pivot table and vlookup questions