I'm organizing alot of aircraft parts out at work and I'd like to use a program that allows me to do a search for a part and it'll tell me where it is. I'm putting all the parts in boxes and placing the boxes on shelves. The shelves are lettered (A-G) and the boxes are numbered (1-12).
So for example, I'd like to be able to type in a part number and it'll tell me which shelf it's on and which box it's in.
Ex: PN324013 ----------> G8
So is there some basic inventory software that does this or is there a function of Excel where this can be done?
Sounds like a simple table you could build in Excel. Once you have all the part numbers in Column A and Locations in Column B, you could hit CTRL+F to find the row of data that contains the part number and location.
If you wanted to get "fancy", you could input the part number in cell A1 and use the vlookup feature in cell B1 to return the location.