here's a udf you might like where r is the row desired

Function an(r As Long)
For i = 4 To 1 Step -1
If UCase(Cells(r, i)) = "YES" Then ms = Cells(1, i) & "," & ms
Next i
an = Left(ms, Len(ms) - 1)
End Function

--
Don Guillett
SalesAid Software

"Jeff" wrote in message
...
Hi,

I have an Excel spreadsheet, where I am trying to put multiple results,
into
a single cell. For example, I have a dropdown selector "Yes" or "No" in a
row that states whether I want a column Market name returned:
a b c d
e
1 Atlanta Chicago Cincinnati
Cleveland
2 Yes Yes No
Yes
3

What I would like to do is this: return results, within a single cell
(say,
a1), all markets that say "Yes", like this: "Atlanta,Chicago,Cleveland".
I
would want them speparated by a comma...

Thanks for any help, it's driving me crazy. I've tried H and V lookups,
and I can bring back one market name, but getting the multiple names into
one cell is baffling.

Jeff