Hi

In H9 copied down on Sales Report

Formula: copy to clipboard
=INDEX('Sales per Catogory'!$A$1:$AO$1000,MATCH(C9,'Sales per Catogory'!B:B,FALSE)+12,40)


Change row 1000 as appropriate