Hello, I am currently working on an excel based project and could use some help on a few things I am stuck on. My project consists of me using an excel spreadsheet to update inventory consistently and efficiently by scanning specific orders into the spreadsheet and it telling me if the item is available, and if so where in the warehouse.
I've already spent some time creating the main spreadsheet and actually have most of it done. What I have completed is one sheet (that is all I need) that is broken down into two different sections. The first (left side) is a column that is blank, but is where I would copy and paste the days orders into. The right side contains the current inventory that was manually counted and entered in. As of this moment, the spreadsheet is doing what I need it to do, but not without some manual work of me looking for specific cells, which always has the potential to lead to a costly mistake.
I have written specific IF functions within the spreadsheet so that when I copy and paste the days orders into the left side, the cells directly to the right will display if it is "INSTOCK" or "NOSTOCK" depending on if the item is available on the Current Inventory column(right side). So to be clear, it quickly searches that whole column and tells me if it is available. Here is my question though...when it does search for that item, and says it is in stock, how can I get it to find that specific items cell, and display that cell to me. The current inventory (Right side) has over 200 listings each associated with a section number to find but I have to manually CTRL+F to search for it after seeing it is "INSTOCK". I just need to figure out a function that IF it is "INSTOCK" tells me where that items cell is.
I appreciate anyone's help in advance.
Bookmarks