Originally Posted by grantt

Hi all

Please see the attached.

I am trying to use the value in column G to find which columns on that row contain this value. I then want to list the column headings for each column which contain that value. So far I have something working that lists the first column heading, but I need to list all column headings, ideally in a single cell separated by commas.

Note that some cells contain the lookup letter, in addition to another letter. These must not be included in the above formula. I also need a way to list the column headings of these guys (which contain 2 letters, one of which is in column G) in a separate cell.

Please help.

Thanks.