Hi All,

I have a sheet of raw data (tab named "Data")about 85 columns wide by
3000 rows. Each row will have a person's name in column A. The name
will appear between 1-5 times depending on how many job codes that
particular person worked for that particular day.

On a seperate tab ("Summary"), I have a summary since the data sheet is
a little overwhelming. What I'm trying to do is the following.

Search for a name in column A. Once the name is located, check cell CQ
of the same row to see if it matches the job code i'm looking for. The
job codes are 505,506,509,511,527. I intend to re-use the same formula
and simply change the code I've entered into it for different sections
of the summary. If the code matches, I want the value of the cell to =
CU of the same row. It's important to note that the same name will
appear multiple times though... if the first one doesn't meet the
condition, I need to check the other entries, not simply ignore them.

Anyone able to shed some light?


--
guilbj2
------------------------------------------------------------------------
guilbj2's Profile: http://www.excelforum.com/member.php...fo&userid=6043
View this thread: http://www.excelforum.com/showthread...hreadid=569391