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