Match Index Help

Roon81

New Member
Joined
Mar 19, 2021
Messages
2
Office Version
  1. 2010
Platform
  1. Windows
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
    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
Joined
Jun 12, 2014
Messages
57,030
Office Version
  1. 365
Platform
  1. Windows
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))),"")
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
57,030
Office Version
  1. 365
Platform
  1. Windows
You're welcome & thanks for the feedback.
 

Watch MrExcel Video

Forum statistics

Threads
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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top