Would someone be able to help with creating a v-lookup, if this is what I should use. I have a list of information in excel on one tab. On another tab I would like to create something like an interface. In that interface I would like to click on a box labeled as a specific category - when I click on this box I would like a list to be created from the list of information in the first tab. I hope this makes sense.
What I want the user to do is click on a box and get the information he is looking for based on a category versus having to scroll through a list of information.
What I want the user to do is click on a box and get the information he is looking for based on a category versus having to scroll through a list of information.