Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Vlookup, COUNTIF, IF or Nested

2 views
Skip to first unread message

Tracey

unread,
Nov 25, 2009, 6:42:05 AM11/25/09
to
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


Pete_UK

unread,
Nov 25, 2009, 6:56:07 AM11/25/09
to
Check out your earlier post.

Pete

0 new messages