Can VLOOKUP return multiple non-empty values from a table?

I have a table.
The table has a list of components down column A, one component per row.
The table has a list of products across the top row, one product per column.
If the component appears in a product, there is an X in the table. Otherwise, the table cel is empty.

Is there a way that I can do a VLOOKUP on the component value, and have Excel return the names of each product in which the component appears?

That is, for a given component (row),
I want to know every product (column)
that contains a value of X (or non-empty cel).

VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
I understand that this would require manipulation of the "col_index_num" field.

Thanks for any feedback!

Hello marathon, Welcome to the forum.

Can you please attach a dummy file with desired outcome? So we can see your data layout. go to bottom click on Go Advanced, then click on Manage Attachments & browse & upload it.

Try:

=IFERROR(INDEX($B$1:$F$1,SMALL(IF(INDEX($B$2:$F$6,MATCH($B$8,Component_List,0),0)="x",COLUMN($B$1:$F$1)-COLUMN($B$10)+1),COLUMNS($B$1:B$1))),"")

confirmed with CTRL+SHIFT+ENTER not just ENTER and copy across.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save