Mimic Pivot - Locate Column Value (not unique)/Return Another Column Value (Summarized)

I have a formula similar to what I'm looking for, but I was curious if there was a better way. I don't know how to describe it other than it's mimicking a pivot table. I want to use this method rather than a pivot, because I'll be summarize lots of information on the same sheet and believe the pivot would be mostly single function.

My current formula looks like:

{=IF(SUMPRODUCT(IF('ALL'!$E$8:$E$900=$A9,'ALL'!K$8:K$900="X")*1)>=1,"X","")}

Also attached is the functionality I'm looking for, although it has no formulas in it. I'd love the second portion of the formula to be more similar to a Match that is looking for a specific value instead of the column count. That way I can set the value it's looking for to the column header like "Product A" in the example instead of Column A.

Hopefully this makes sense....thanks!