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). 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) 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