I am trying to create an inventory spreadsheet. I would like to be able to select my "Item" from the drop down list, and have the "Part Number" fill in automatically. I would also like to be able to do this in reverse - select my "Part Number" and have the "Item" list narrow down with only applicable items. Is this possible?

Posted 4 years ago