Find Multiple Match Results in Excel (Easier Solution For ALL Excel versions)

Microsoft Excel

Finding an Excel solution to get MULTIPLE matches for a lookup value is often causing major headaches. The go-to VLOOKUP formula does not work here because it just returns the first match! What if you wanted to use VLOOKUP but return ALL matches?

Credit Leila Gharani