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...
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.