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 its located to update new inventory received number. I have been trying to use Vlookup, lookup, xlookup, find, and many more. They don't seem to work for me or they do and it pops up where i need to go then doesn't work again. Currently i have in =vlookup(block where i enter my part number im searching, section of all my part numbers, section where my new inventory count goes, "false" for true)
this isnt working it isnt bringing up current inventory count nor letting me know if the part number entered in in the parts.
Thank you
7 Replies
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.
Thank you for that, here is the only sheet i want to work with once i have it all together.
i will create a section that i search for my part numbers .
A single data table would NOT have all the blank rows. That makes it more readily readable by humans, but you're asking a computer to do the reading.
One of the major mistakes made in designing a spreadsheet where you want LOOKUP (in any of its various manifestations) to work, is to make it pretty. Eliminate the colors, eliminate the blank rows. Add a column to take care of (recognize) the different sections.
