Question: can vlookup return an array?
Answer: As mentioned in the beginning of this tutorial, there is no way to make Excel VLOOKUP return multiple values. The task can be accomplished by using the following functions in an array formula: ... INDEX - returns an array element based on the row and column numbers you specify. ROW - returns the row number.