I am trying to return multiple (>=0) corresponding values (placed above the lookup value row) when I lookup a specific text "Yes" in the corresponding row.
This may be confusing, please refer to screenshot for details.
KeywordCapture.JPG
Essentially, I want to list out the Keywords (Row 1) that contains specific keywords (A2 for example, the formula to return corresponding values "101 Dalmatians, 101 Dominos, 100 101 102")
I tried using formula {=INDEX($B$2:$B$8, SMALL(IF($A$11=$A$2:$A$8, ROW($A$2:$A$8)-ROW($A$2)+1), COLUMN(A1)))}
from here: http://www.globaliconnect.com/excel/...=77&Itemid=473
But failed to make it return proper values...
Please advise on how I should go about accomplishing this objective.
Thank you,
Bookmarks