Forum Discussion
Parts inventory
Hello, im getting together a parts inventory. Im searching for a formula that when i receive my parts packing list with received parts i can enter in my part number and it takes me right to where it...
Not sure where you're wanting that formula, what you're entering, where you expect it to look.
BUT, a big suggestion, which I strongly recommend: combine those four separate inventory lists into a single, just adding one column (if truly needed) that recognizes the category that is now reflected in the individual tab. It would be a small amount of work.
Here is an image of the current column headings, with minimal change (I moved the "Description" heading in the Maintenance category). Other than that, as is immediately evident, they all have virtually identical column headings. So a single database would serve your purpose and make it a LOT easier to search.
Once that's been done, your LOOKUPs should work fairly easily.