=IFERROR(INDEX(Sheet1!B$1:

This formula will return the first, second, third result from Sheet1 column B when Sheet1 column A contains the same value as cell A5. The formula returns an empty string (looks like a blank) when there are no more matches.

The above formula must be array-entered. To do so:

1. Select the cell

2. Click in the formula bar

3. Hold the Control and Shift keys down

4. Hit the Enter key, then release all three keys

Excel should respond by adding curly braces { } surrounding the formula. If not (or if you see a blank when there should be a value returned), then repeat steps 1 through 4

MultipleMatchesQ28323513.xlsx