T
Tracey
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
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