hello everyone, i recently created a stock managing table in excel and it works perfectly, and here is the file
there's the item name of course, and next to it the current QTY (availability), which from time to time gets deducted, well can there be a formula elsewhere or in the same sheet, a table of a Vlookup or other, maybe with the items in it, with numbers next to them which can be considered as minimum QTY and it would work in a sense where if it hits or decreases more then the following number it would warn me in the original table next to the item QTY, and i wouldn't mind if the vlookup table is in the same sheet or if its a big table since every item has its own unique minimum quantity
so the Vlookup table may look something like:
if this particular item has QTY Lower then 5, the following message will pop up in the original table
and every item would have a different QTY limit,
Bookmarks