I'm having trouble on something with Google Sheets: I need category names to be dynamic & extendible between 15-200 values, so it's not quite worth an Apps Script, would be super cool to put the following formula
=QUERY(A1:C4, "SELECT COL WHERE" &A1:C1& = &E8&)
in such a place as it could reference the dynamically selected dropdown in Cell E8, and return all the values in a dropdown in F8. I've seen videos of dependent dropdowns and 'helper columns' but I think this can be done with query, and putting that formula INSIDE the data validation formula field on that cell. Thoughts? I think the formula is close - it should use E8 to 'select that column, then return all values below it.'
QUERYcan be a bit tricky for sure.