I'm working with some raw data exported to Excel from some tracking
software we use. For each of our agents (call center), there are
between 1-5 entries. In column A, their name will appear anywhere from
1-5 times (always consecutively) to show stats for each of the queues
they may have worked on from that day. Column CQ has the number code
associated with the queue. What I'm trying to do is use Vlookup to
locate their name, but only return data if CQ of the same row meets a
value (509) that I specify. If the value in CQ of that row does NOT
meet the criteria I specify, I need it to then check the next row and
the next row until it finds the row that does meet the criteria. In
the advent that none of them do, I plan on simply leaving the cell
blank. I'm comfortable with teh basics Vlookup and =IF, but I'm
afraid that making the two work toghether to get this done is beyond
me. Any help any of you could offer would be most appreciated.


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