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

[marathon]

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?

Thanks to all for any assistance or feedback!

[marathon]

To clarify:

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

[marathon]

I have .zipped and uploaded a dummy file, "table_example.xls," attached here.
I am using Excel 2010.

I have cross-posted this question to excelforum.com, and may post in mrexcel.com. If I receive a helpful reply on any forum, I shall share that information on the other forums, with due credit. I'll also mark these threads as solved once a solution can be described.

[marathon]

Tremendous thanks to MrVillareal and NBVC! I'll study both of these solutions to learn from them. MrVillareal's solution appeared on the mrexcel thread:

=IFERROR(INDEX($B$1:$H$1,AGGREGATE(15,6,
(COLUMN($B$1:$H$1)-MIN(COLUMN($B$1:$H$1))+1)/(($A$2:$A$6=$B$8)*
($B$2:$H$6="x")),COLUMNS($B9:B9))),"")

enter into cell B10, and copy across.

NBVC's solution appeared on excelforum thread:

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

This thread is solved. Now, to learn how to MARK the thread solved. Thanks again to MrVillareal and NBVC for the education.