Excel 2007 : Lookup and Concatenate help

[jonesdogg]

Hi,

I am new to the forum, so pls forgive me if I make some cardinal sins with what I am posting.

I am looking for a solution to what very well maybe a simple problem.

I have attached a sheet with an example of what I am trying to do.

If you can help in anyway I would very much appreciate it.

Thanks

[teylyn]

Hello,

a bit pedestrian, maybe, but worth a try

=IF(B3="yes",A3&", ","")&IF(B4="yes",A4&", ","")&IF(B5="yes",A5&", ","")&IF(B6="yes",A6&", ","")&IF(B7="yes",A7,"")