Hey all, I am working on an inventory sheet which thankfully is getting close to completion. However, I am having trouble creating a lookup. I have a master inventory workbook that I am using VLOOKUP to pull data from. However, I want to be able to use two different criteria to search for it. For example, a item will have a serial number (or NSN as I have it listed) but will also have a name. I have the ability to search for an item by NSN and auto fill the name, but I need my spreadsheet to also do the reverse. I need to be able to plug in the name and have it autofill the NSN, or plug in the NSN and have it auto fill the name. Right now I only have the latter of these. I will attach a copy of the Masterlist Workbook and the Inventory Test Book to play around with if that helps.
Bookmarks