Vlookup with nested IF


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?action=getinfo&userid=6043
View this thread: http://www.excelforum.com/showthread.php?threadid=568374

.

Relevant Pages

  • Re: Vlookup with nested IF
    ... 1-5 times to show stats for each of the queues ... value that I specify. ... the next row until it finds the row that does meet the criteria. ... I'm comfortable with teh basics Vlookup and =IF, ...
    (microsoft.public.excel.misc)
  • Re: Fundamental axiom of tennis debate
    ... of his era, or the best of his era, or anything else, because of his ... specify the generally applicable qualifications needed -- and then ... live by the result when those criteria are applied -- then you have ... not slams, ...
    (rec.sport.tennis)
  • re: Database Results Wizards, More Options, Criteria, Comparison.....
    ... When you run the DRW and specify criteria, ... those criteria end up in that SQL statement. ... Field Comparison Value Form Field And/Or ...
    (microsoft.public.frontpage.client)
  • Re: Report parameters
    ... criteria to work with fields on the parameter selection ... >> causes frmSpecifyRecord to appear. ... The criteria for the EmployeeID ... >> specify both Name and a date range. ...
    (microsoft.public.access.reports)
  • Re: header problem - want to display html AND download a file
    ... > database and then create an excel spreadsheet and download it to their ... > various fields and criteria to specify for the search. ... > once the user clicks the button to submit the query the file ...
    (comp.lang.php)