Is there a way (array formula, row() function, etc.) to return the instances of, say, a club where two criteria are met. For example, if I have a list of clubs, each of which is categorized by size (Large or Small) and traffic (busy or slow); How could I write a formula (array, I assume) to return the clubs that meet a specific combination (e.g. Large, Busy)?
Attached is a spreadsheet showing what I'm talking about. The gray area is where I'd like to return the values. I can make the box as big as the list, then return a "" when the last value is returned.