Formula for pulling the counts on items in i different locations but with same name

[svis89]

=XLOOKUP([@Item]&[@[Bin Number]],Item19&Bin_Number19,"@[Count19]","",1)
=XLOOKUP("[@Item]='R19'!@Item19*'Calculate sheet'!@[Bin Number]=@'R19'!A3:A68",Item19,Count19,"",1) this only pulled the first instance of the same name

I tried the above and a few other variations but could not get the result i want... i have a work book with 33 work sheets for a cycle count running through-out the year i am trying to create a catch all formula that will look up the item name and the locations and if they match my new sheet return the correct count right now im trying using define names for the data areas 2-33 the above shows for sheet 19 its saying look at the item and bin number match the result on page nineteen and if it does give me the count that was added for this cycle count.... it does not have to be xlookup that is just what im used to using since i just am not allowed to use macro's anymore lol
I will keep trying different things on my end i have always got good help here

 

[svis89]

Okay so tell me if you see a problem with the following Con and Con_23 are the columns i used text join on
=TEXTJOIN("-",TRUE,Table2[@[Bin Number]],Table2[@Item]) to combine to two criteria and then
=XLOOKUP(@Con,Con_23,Count23,,1)
now i think this would do what i want looking up both the specific bin location and the item name so it should only pull the count for that particular item

 

[svis89]

Okay so tell me if you see a problem with the following Con and Con_23 are the columns i used text join on
=TEXTJOIN("-",TRUE,Table2[@[Bin Number]],Table2[@Item]) to combine to two criteria and then
=XLOOKUP(@Con,Con_23,Count23,,1)
now i think this would do what i want looking up both the specific bin location and the item name so it should only pull the count for that particular item

i know it isnt exactly what i asked for but it is the closest i can come up with unless you can create a formula that would be able to search columns a and b in a way that would treat it as the text join does i cant find a good way to do it