Thank you Rob...two questions...
Which cell do I put this formula in and will this work for 15,000 cells? I
have a sheet and wish to make it a template where I can import other data
daily into this template so that it will automatically use these formulas so
that I don't have to imput the formulas for each sheet...hope this makes
sense...

Thanks again!

"Rob van Gelder" wrote:

=IF(AND(D1="Mel Rosenfeld", D2="Mel Rosenfeld", D3="Mel Rosenfeld"), A1 & ",
" & A2 & ", " & A3, "")

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"mel" wrote in message
...
Search for same text in column D and find...
if column D1, D2 and D3 =
Mel Rosenfeld
Mel Rosenfeld
Mel Rosenfeld
then combine/concatenate corresponding cells in column A
A1, A2, A3 into cell A1
123 Main Street
55 Main Street
28 Main Street
so that cell A1 = 123 Main Street, 55 Main Street,28 Main Street