I have a file that has a tab full of data, and a tab where you can enter a bunch of cells and it automatically pulls, via vlookup, from the data tab the corresponding information. It's customers and their item codes.
Sometimes it pulls the wrong customer's information if they happen to have the same item code as the one I want. I'd like to add at the top a drop down where I can select the customer whose item codes I want to search for. How can I do that?
Sometimes it pulls the wrong customer's information if they happen to have the same item code as the one I want. I'd like to add at the top a drop down where I can select the customer whose item codes I want to search for. How can I do that?