I wonder if you could advise: when I set my regular vlookup. And have found the requested result. How do I get excel to keep searching for further results that fit my condition. For example. I want to have all the Peter listed and not only the first one the function finds from a list.
Any suggestions please?