# VLOOKUP to extract multiple results - without vba

#### tinferns

##### Board Regular
Now, here's a tough one.... I am trying the below 2 formula's to obtain multiple results using index & Match formula. Doesn't seem to work. I am using Excel 2019 and Office 365. I want to avoid using VBA.

Formula's (options) used:
Index + Match1 = {=INDEX(\$B\$3:\$B\$988,SMALL(IF(D3=\$A\$3:\$A\$988,ROW(\$A\$3:\$A\$988)-ROW(\$A\$3)+1),ROW(2:2)))}

Index + Match2 = {=INDEX(\$B\$3:\$B\$987,SMALL(IF((D3=\$A\$3:\$A\$987),MATCH(ROW(\$A\$3:\$A\$987),ROW(\$A\$3:\$A\$987)),""),ROWS(\$C\$2:C2)))}

Thanks....

#### Attachments

• Index n Match1.png
69.3 KB · Views: 10

#### Fluff

##### MrExcel MVP, Moderator
You're welcome & thanks for the feedback.

### Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

Replies
7
Views
185
Replies
3
Views
105
Replies
1
Views
46
Replies
3
Views
52
Replies
2
Views
180

1,127,788
Messages
5,626,890
Members
416,208
Latest member
tan21

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back