I have a large spreadsheet containing five columns and about 15,000 entries. Each entry is for a specific part my company uses. The five columns are "Account Code," "Vendor," "Part Description," "Part Number," and "Price."
I want to create a series of drop-down menus to make this sheet more accessible. I want it so that a user would first select an Account Code from the first drop-down menu. Then, they would select a Vendor from the second menu. But the list of vendors available would already be filtered by that account code. Next, they would select a Part Description from the third menu, but only the part descriptions from that account code and vendor would show up. So it would basically be like a tree.
Account Code #1
|___Vendor #1a
|___Part Description #1ai
|___Part Description #1aii
|___Vendor #1b
Account Code #2
|___Vendor #2a
...etc.
Ideally, each sub-level would only accept entries that corresponded to that sub-level. If that makes sense.
Finally, once a part is selected, I would like the corresponding part number and price to be displayed. I did a bit of research and people seemed to think the best way to do this was with a vlookup and the indirect() function but I have no idea how to implement these.
Thank you in advance!
Bookmarks