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!
Bookmarks