Question: can hlookup return multiple values?
Answer: Use of HLOOKUP to return multiple values from a single Horizontal LOOKUP. ... If you wish to get an array, you need to select the number of cells that are equal to the number of rows that you want HLOOKUP to return. After typing FALSE, we need to press Ctrl + Shift + Enter instead of the Enter key.