Question: when vlookup has multiple matches?
Answer: Vlookup multiple matches and return results in a row. Like in the previous example, both are array formulas, so remember to press the Ctrl + Shift + Enter shortcut to complete them correctly.