Use the data from the yellow highligted cells to populate the report. Use INDEX$/$MATCH$/$MATCH to populate cells B$23$:C$29$ of Report A and use Nested XLOOKUP to populate cells B$34$:D$45$ of Report B$.$