Wow...thanks all. My first post here, and I'm beyond satisifed. I can't
believe I spent a couple hours on this, and I didn't have an ampersand (&) in
my formula. But that did it! And thanks for the tips on the commas, too, I
can do with having some extra commas in there when the Market says "no".

Thanks again!!!

"Rick Rothstein (MVP - VB)" wrote:

This formula will do it, but won't handle the comma and space sequence you
want between the cities. You'll get AtlantaChicagoCleveland.

=IF(B2="Yes",B1,"") & IF(C2="Yes",C1,"") & IF(D2="Yes",D1,"") &
IF(E2="Yes",E1,"")

To handle the commas and spaces with a formula might send me into therapy.
Someone might find a manageable way

What about like this...

=SUBSTITUTE(IF(B2="Yes",B1&",","")&IF(C2="Yes",C1& ",","")&IF(D2="Yes",D1&",","")&IF(E2="Yes",E1&",", ""),",","",COUNTIF(B2:E2,"=Yes"))

Rick