Hello,

I could use a little help here. I've tried different formulas I've found through these threads but just can't get anything to work. I'm looking for formulas that could get me where I need to get, not looking for a vba script.

I've attached an image of what I'm looking at, and for.
Capture.JPG

I want to search by column A and find all instances of x across the row, and then have the results show all column headers where x is found.
My search value is in B9, and hoping to get the results in B11:B17.

Thanks,
Ric