formula that checks a cell for equal or less value

Hello. I'm trying to finish a school project using excel. What I am trying to create is a Inventory/To-Buy receipt/Sales Receipt.

I already have almost everything ready BUT i am missing the knowledge of how to properly set up some functions I want it to have.

Inventory: I have a Minimum quantity, Current Qty, and Required Qty cells. Min and Req Qty are set numbers using the vlookup formula with the Type of Product cell. As soon as I set the type of product it is, it automatically looks up the value of Min and Req Qty.

Now Current Qty is set manually and here is the part where I need help. I have a To Buy cell that would check if the value is equal to or less that Min Qty cell and post itself on the To-Buy receipt with name(or product) and the amount to buy.

I'm really new to excel that is why I resorted to ask for help. If this was the wrong section sorry.

Hello,

could you possibly upload a sample file? That will be much easier to understand. Manually put in the expected result, so we can see what we're aiming for.

cheers

OK,

so in your sheet "SalesBook" you have

Please Login or Register  to view this content.

What would be the expected value for "precio"?

Your data does not have "Bizcochos" in any of the lookup sheets.