Check out your earlier post.

Pete

On Nov 25, 11:42*am, Tracey wrote:
Hello,

I have a work sheet "Raw Data" of about 1500 rows and 30 Columns. In columns
K, K, L, M, T and W are names of staff. In worksheet "Lookups" I have a
defined list of "Leavers".
I need to return the names of the leaver/s in the last column of the "Raw
Data" sheet.

eg:

Row 15 *Column K contains "Joe Blog" Column M contains "Micky Mouse" and
Column W contains "Jane Doe". in my defined list of leavers "Joe Blog" and
"Jane Doe" are listed, in the last column of the "Raw Data" I need it to read
"Joe Blog, Jane Doe"
also, one name could be in multiple columns in the same row.

Your help is greatly appreciated.

KR
Tracey
P.S I'm using Excel 2002