XLOOKUP missing a bunch of data - I must be an idiot

Spent about 3+ hours wrestling with this 'simple' lookup - I want it to pull all the matched codes on the "Draw From" tab, to the "Lookup" tab.
Then I want to click on the count filter to show me, in descending order, the codes that have a quantity assigned (in this case, all codes have a quantity)

Seems like a VERY SIMPLE formula - right?
=XLOOKUP(A2,'Draw From'!$A$2:$A$51,'Draw From'!$B$2:$B$51,0,0,2)

But as you can see, this formula only returning 2 of the 50 codes
Is it a cell format issue?



. o 0 ( I know it's something simple )

If there is no 365 version XLOOKUP function , change the lower version method

worksheet name : Lookup
Cell B2 formula , Drag down

HTML Code: 

Had to add a zero to the final "0" so I can sort it numerically, but that seems to work Thank you

Still scratching my head as to why the XLOOKUP returned only 2 of the 50.... I don't think a formula should 'kinda' work