Ok, no problem.

I'm getting ready to break for dinner but I'll get on it when I'm back.

Biff

"MichaelG" wrote in message
...
Sure can. On a second sheet in the same workbook, I have something that
looks like this:

Count of Status 1 Count of Status 2 Count of Status 3, etc.

For that I'm using a simple =COUNTIF('Pipeline Data
Sheet'!$E$3:$E$75,$A11)
where E3:E75 is a column containing each project's status and A11 is the
particular status.

What I would like to see is something like this:

Count of Status 1
Project 1 in Status 1 (acutal name of project from Project Name column)
Project 2 in Status 1
Project 3 in Status 1

... and so on for each of the status columns. As the projects are moving
through their life cycle their status changes so the lists need to
dynamically update. This lists of project names are used as supplemental
information on a pipeline chart. Until now I've been doing filters by
project status then cutting and pasting data. Does that help?

"Biff" wrote:

Hi!

Can you better describe how this is setup?

first two columns in the worksheet are Project Status, Project Name.

That's easy enough to picture but what about the other sheet where you
want
the data extracted to?

Biff

"MichaelG" wrote in message
...
I am working with a project status report where the first two columns in
the
worksheet are Project Status, Project Name. On another worksheet, in
columns
(by status) I have a set of simple counts of each status. Easy
enough.
Below each of the counts by status, I would like to create a list of
all
the
projects in that particular status. I've messed around with VLOOKUPS
but
can
only find the first value in the range matching the criteria. I've
also
messed around with vlookups in an IF statement, but still can't figure
out
how to do this. Does anyone have ideas?