sorry if this is a double post I couldn't tell if the last one was
posted.
----

Ok. Still not getting it so hang in there with me. Let's try the easier
one first.

I am trying to match the following text in cells (RawData!AD14:AD100)
text = "Not Started" If there is a match, I need to pull the "project
managers name" located on the same sheet in cells (RawData!D14:D100)

This information needs to go to (Overview!A5:A100). I need to be able
to copy this formula down so it pulls all of the projects manager name
by "not started" and leaves blanks below if nothing matches.

The next cell to the right (Overview!B5:B100) needs to pull the
information for priority number for the same projects "not started"
(RawData!AD14:AD100) pull the priority number from (RawData!A14:A100).

Thanks for your help


--
streetboarder
------------------------------------------------------------------------
streetboarder's Profile: http://www.excelforum.com/member.php...o&userid=30707
View this thread: http://www.excelforum.com/showthread...hreadid=534271