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?