sorry if this is a double post but I didn't get a response from my
previous post and I need to finish this workbook up by the end of the
week.
----

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

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

So in the end I will have "Projects Not Started by Manager".

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=534553