Match Index Help

[Roon81]

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

 

[Fluff]

Hi & welcome to MrExcel.
How about in B10 dragged down & across

=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]

Perfect! Thank You!

 

[Fluff]

You're welcome & thanks for the feedback.