Inventory Audit using XLookup w/ multiple criteria
I've been working on a spreadsheet to keep track of some inventory. It has how many units entered and exited each day, for each item. Using this information, I have then compare it to the list of in/out inventory sent to us by a third party, basically to confirm that our numbers and their numbers match.
This is where I'm struggling. I can't seem to find an efficient way of comparing these numbers that works. I've tried XLookup and Nested formulas, Index Match, etc and nothing seems to be working.
I need the "total" numbers for each day from the first image to go into the "Double Check" column on the second image, matched for the item and date.
I'm not sure if it's an issue because some is horizontal and some is vertical?
Would love if anyone had a solution or better method to do this, thanks!
Edit for more info: the image with the inventory, the "in" and "out" columns both pull data from a separate sheet that has all of the relevant information and then the "total" column is a formula that just sums the in/out with the previous days' inventory count.
[link] [comments]
Want to read more?
Check out the full article on the original site