On a matrix: If cells are marked, show table header value in corresponding row (with line breaks).

[Chuck Rittersdorf]

What is the best way to do the following:

If one (or more cells) within a range on a matrix is marked (e.g. with "X"), show the value of the header in that column in the cell of the corresponding row left in the matrix (column B in my example).

If more than one cell (on a row) is marked, the values should be shown separated by a line break (on Mac and PC, I've heard there are issues).

Here is an image to explain what I mean:

I've tried an IF-function, but it does not accept ranges. I've considered Lookup, but my Excel-skills are too limited to use it... I'm working on a matrix with lots of rows and columns, so I need something copyable and hence time saving.

Please advice and thanks for your help.

 

[Eric W]

You might get it to go a little faster if you put

Application.ScreenUpdating = False

before your loop, and

Application.ScreenUpdating = True

after it. Other than that, I'm just glad you got an acceptable solution!

 

[Chuck Rittersdorf]

Feels a bit quicker now...