Is there a way of creating a dropdown that is dependant on another cell, and looks up the values in the row rather than the column?
I have a lookup sheet that has a list of terms in column A, and a series of sub-terms for each entry in cells in that row. I can create a drop down in the main sheet that allows me to select the main term, now I want a second dropdown that gives me a list of the sub-terms for the selected main term.
The only examples I can find seem to look vertically rather than horizontally.