+ Reply to Thread
Results 1 to 1 of 1

Create possible HLOOKUP, VLOOKUP, INDEX, MATCH to search 2 criteria and return data

  1. #1
    Registered User
    Join Date
    04-09-2013
    Location
    Coventry
    MS-Off Ver
    Excel 2003
    Posts
    8

    Create possible HLOOKUP, VLOOKUP, INDEX, MATCH to search 2 criteria and return data

    Hello,

    Thanks in advance for looking into this.

    Please see attachment - I am stuck on this one....don't know how best to proceed.

    We'll take the first agent in cell A2 as an example. On the 4th Sept the agent was scheduled to work as C2 and D2 indicate but she was on EAL. So in cell ref E2 I need to show the start time of the EAL taken on the 4th and the end time in cell ref F2. The data for which appears in H2:L117, so it would show 0900 & 1715. Only issue being, there is more than one line of data for that agent for the 4th.

    So in essence I need some sort of lookup that will look up the agents name and the date in A2:D37 and identify if they appear in the data H2:L117 and return the start time and end time in cells E2, E3, etc and F2, F3, etc...

    Hope that makes sense...

    Thanks Chris
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Return Multiple values from a column with index and match, and search criteria
    By marcusduton in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 02-15-2015, 09:59 PM
  2. Replies: 2
    Last Post: 09-25-2013, 07:18 PM
  3. Replies: 2
    Last Post: 06-29-2013, 11:58 PM
  4. vlookup? match? index? MULTIPLE criteria for vlookup search problem....
    By aborg88 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 02-11-2013, 09:56 AM
  5. [SOLVED] Search in Table vlookup / Hlookup or INDEX - MATCH command
    By dalaie in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 09-13-2012, 07:42 AM
  6. [SOLVED] INDEX-MATCH function return '0' if search criteria not found
    By Ben.SFM in forum Excel General
    Replies: 2
    Last Post: 04-27-2012, 01:46 PM
  7. Replies: 3
    Last Post: 08-17-2010, 02:54 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1