I have NO idea where to start, what to learn, or what to search for..
This may be something I have to do in Access and it may be easy and basic, but I've never used any MS programs but Excel and Outlook, so help a brotha out!
What I need to be able to do is this:
Use a variety of drop down menus to find a result that matches all the specifications selected. What I’m looking for is to be able to have one worksheet reference a database and filter what the right product is by the requirements selected.
I would create 3 or 4 drop down menus..
The first is loaded with a list of cells just like you would normally do using data validation/list.
The second uses the value selected in the drop down as its lookup value in an hlookup-ish type function, looking one column to the right. I would need this list to display values found in ALL rows found in the range that includes the lookup value selected.
The third acts the same as the second and displays all values not already filtered out.
This should give me the one result I want
Bookmarks