vlookup or index match, to manage quantity?

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,

you can do that , i'm just not sure which sheet or columns we are looking at

you could compare the current qty with the set minimum

so if
cell with current < vlookup( unique item reference , table to refer to , column to lookup , false)

then you could use conditional format to set the cell colour to green or red, you could even have yellow if within a %

but i need to know where the quantity in stock and the reference qty are set in your sheet

oh yes i will tell u im so sorry for the late reply and i didn't specify the sheet its the receiving sheet and its the current QTY which needs to be the set on the formula, the column which has current QTY cuz that is the column which is getting deducted from !


but i forgot to mantion there's an operating formula in the Current QTY would that be a problem? if yes its ok i guess im thankful enough for u looking at my problem

i created a sheet called stock level
and then use a formula for conditional format

=G10<=VLOOKUP(B10,Stocklevel!$A$1:$B$16,2,FALSE)

the issue will be the item name would have to be unique and exactly the same on the stock level sheet as on the receiving

see attached

change the stock level sheet and you will see the cell fill changes colour if qty less then set in stocklevel