Vlookup, COUNTIF, IF or Nested

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

HELP! Lookup, countif or if statement 3
Please Help - Trouble with counting occurrences in external file 2
Copy to another worksheet IF 3
multiple match 4
IF FUNCTION? 6
Need to match 2 columns, if a match found add info from 2nd column 1
Extract text from cell 9
combining or "flattening" rows 6

Top