Hi, I am trying to generate dynamic lists based of different length. For example, in column B I have a country name. In column C I have an industry (e.g. automotive, pharmaceuticals etc.) and in column D I have company names. So my goal now is to generate a list of all automotive companies for various countries. I hope to find a solution, where I simply select country and industry (maybe in a drop-down) and then get the corresponding list of company names. So it is not a one-to-one match as I would get with a vlookup, but a one-to-many match (with the number of results also varying...)
Solved by Z. W. in 23 mins