Pergunta de entrevista da empresa Johnson & Johnson

Excel exercise. Pivot Vlookup. Real problem and related quest.