=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
=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