Forum Discussion
Parts inventory
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.
- All i want is my search bar where i enter in a parts number to locate where in the parts # is in line A and line I the current inventory amount.
Hi Shareena
Here play with this
you select the part number using a drop down, you can type a few of the number to narrow your search in the drop down list:
for example, you type HK in the drop down then press the drop down arrow:
then press ctrl+alt+F5 to refresh the search screen
then it will show the stats related to the part number and the row its located in the inventory table
- the bank sections are to add more parts. so you saying to not have the blank spaces?
