# Match Index Help

#### Roon81

##### New Member
Hello,
Im hoping someone can help me with a Match Index formula involving sheet1 & sheet2.
I have a 3 column table ( C:4-E:51) on sheet1. Within the table, If a cell in Column C on sheet 1 has an X, I need the info in Column D & E, to populate
in a 2 column table on sheet2 ( B:10-C:32). Hopefully the image below better explains. Thanks in advance, I have been attempting this on and off for several days and reading several other post
and can only seem to get the first item selected to populate on sheet2. Thanks, Roon

#### Attachments

• Match_Index.jpg
26.2 KB · Views: 6

### Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

#### Fluff

##### MrExcel MVP, Moderator
Hi & welcome to MrExcel.
How about in B10 dragged down & across
Excel Formula:
``=IFERROR(INDEX(Sheet1!D\$4:D\$51,AGGREGATE(15,6,(ROW(Sheet1!\$C\$4:\$C\$51)-ROW(Sheet1!\$C\$4)+1)/(Sheet1!\$C\$4:\$C\$51="x"),ROWS(B\$10:B10))),"")``

#### Roon81

##### New Member
Perfect! Thank You!

#### Fluff

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

Replies
4
Views
51
Replies
26
Views
1K
Replies
15
Views
503
Replies
5
Views
79
Replies
2
Views
58

1,130,425
Messages
5,642,042
Members
417,251
Latest member
Dordrecht

### 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