Matrix: Identify cell content in column for a row if matrix content true

Example 1.xlsx

Hi,

Thanks for your comment. I have attached an excel example identifcal to the one I tried to insert via text.

T

OK, but you haven't indicated what result you are expecting.

I basically want to know which activity types correspond to a certain terrain that are a yes.
So the result would be a list.
There are two variable and a set of results, the row cell which could be 'offroad' for example, and the matrix content which could be n (no) for example. So the result would be 'run and swim'.

Does that make sense?

Many thanks,

T

But can you address the question in post 2?

A formula: If "Road" is in G1 and "y" in H1 then this in F4 and copy down as far as necessary.

=IF(ROWS(F$4:F4)<=COUNTIF(OFFSET($B$3,1,MATCH($G$1,$C$3:$E$3,0),4,1),$H$1),INDEX($B$4:$B$7,SMALL(IF(OFFSET($B$3,1,MATCH($G$1,$C$3:$E$3,0),4,1)=$H$1,ROW($B$4:$B$7)-ROW($B$4)+1),ROWS(F$4:F4)),1),"")

Enter with Ctrl+Shift+Enter.

Thanks a lot however I can't seem to get your forumula to work. I used the example I attached and placed the 'road' and 'y' in the noted places. Pressing Ctrl+Shift+Enter didn't seem to do anything.

I thought I answered your question in my last post but perhaps I misunderstand, could you re-explain what you meant?

Many thanks,

T

Ok thanks fo sending the example sheet, helped a lot. I didn't realise you had to select the forumla as opposed to the cell when doing Enter with Ctrl+Shift+Enter.

Works perfectly and was exactly what I was after.

Thanks a lot,

T