Selected Answer
Hi Lorie and welcome to the Forum
The bold part below in your formula (e.g. in cell D3):
=IFERROR(VLOOKUP(@$B:$B,$N:$AA,6,0),"")
attempts to look up B3 in coulmn N of the Warehouse table and return column 6 (=S).
The problem is that the value of B3 (M000001) is not unique- it appears in column N rows 3. 4, 5 and 6. Excel this returns only the first match and you have "missing figures".
In the attached file, I've fixed that by making D3 look up the unique value in your column Q (Join) by concatenating the column heading (e.g. D2) to the value of B3 and looking in a redefined range. The formula in D3 is:
=IFERROR(VLOOKUP($B3 & " - " & D$2, $Q:$AA,3,0),"")
The column index is increased per column up to L then the formulae copied down.
REVISION:
Given you later stated that the VLOOKUP should be done on the hidden sheet "Bulk", the above formula needs to be changed to refer there. Range references to $Q:$AA become Bulk!$D:$N so the formula in cell D3 iof your List sheet becomes
=IFERROR(VLOOKUP($B3 & " - " & D$2,Bulk!$D:$N,3,0),"")
This is implemented in the second file below, "work with VLOOKUP on hidden sheet v0_b.xlsx".
Hope this works for you.