Hi There,
I want to use 'Offset' within an 'IF' function formula for an inventory spreadsheet.
Scenario
Each day I receive a daily inventory report for rolling stock counts to be carried out. When I receive the stock count sheets back I then input the results of the physical counts in the 1st Count table. This gives me a result that is either correct or wrong. Correct in that the physical count tallies with the inventory system report, or wrong when they do not tally, which is reflected in the difference column. Dependent upon the results of the physical count, it is determined whether or not a 2nd count is required, or even (after a second count) a 3rd count, leading potentially to an investigation of stock missing, or too much stock.
Attached is a mock up of the spreadsheet I use. It is pretty much self-explanatory, but what I want to do is use an 'Offset' function within an 'IF' formula that will pull the non-tallying results only into the 2nd count table. That is to say bring the 'Part Number', 'Warehouse', and Location of the non-tallying part and place it under the appropriate headings in the 2nd count table. I also want it to do the same operation for non-tallying quantities of the 2nd count results and place them into the 3rd count table. The idea being that at each count stage the size of the counts reduce, after eliminating 'miscounts' and the finding of the missing amounts
For instance, if the first count had 20 parts to count, in an ideal world all 20 counts would tally and no further counts would be required. However, there may be some counts that do not tally, and these would have to have a 2nd count, or even a 3rd count, leading to an investigation if necessary.
What would be the syntax of an 'IF' formula with an 'Offset' function to bring the non-tallying parts to the 2nd count table, or if necessary the 3rd count table?
All help would be greatly appreciated.
Regards
Aristillus
Bookmarks