I would like excel to bring, from a specific table, all the rows of a column that has the same header name as a particular cell outside of this table. If cell A1 = Name of a header in table X, then, excel returns all rows in the column of this header.
the table is on a different sheet in the same workbook. The table has about 200 columns and 2000 rows.
Enter the formula with Ctrl + Shift + Enter:
INDEX(range,...): is the range where to return value (return range)
ROW()-1: is the row we want to return from our return range, and -1 for header.
MATCH(1,--($A$1:$C$1=$E$1),0): is the column where we can find your search value and
$E$1 is the cell with the drop-down list