I have a list of inventory,'Register', with columns "Quantity on hand" & "Minimum Stock Level" as my criteria. I have a formula that I thought would work but in every cell it pulls the same cell. I want another table, on another workbook, to populate everything from the 'Register' if it meets the following criteria.
Criteria 1 (ignore If "Minimum Stock Level" is blank), Criteria 2 (If "Quantity on hand"<="Minimum Stock Level").
I know how to do this based on the criterias, however, the way I know how would not ignore blank cells and therefore I would have to filter out the blank cells. another person, not so familiar with excel, will be using this table to approve orders.
I hope I am clear.
Bookmarks