Hello
In cell B8 copied across and down:

=HLOOKUP(INDEX(reference!$A$1:$A$10,MATCH(B$7,reference!$B$1:$B$10,0)),'Dbase Export'!$AL$5:$AU$8,MATCH($A8,'Dbase Export'!$B$5:$B$8,0),0)
This is just referencing your sample data, you would of course need to expand the ranges as needed.

Hope this helps.
DBY