Results 1 to 5 of 5

Multiple Criteria lookup to extract data from a dump - INDEX MATCH????

Threaded View

  1. #1
    Registered User
    Join Date
    03-06-2012
    Location
    Thunder Bay, ON
    MS-Off Ver
    Excel 2007
    Posts
    19

    Multiple Criteria lookup to extract data from a dump - INDEX MATCH????

    I am attempting to extract data from a dump onto a blank sheet in a workbook, I would like to create a formula that will look at 3 separate reference items, so that it will pull the correct data.
    i.e.
    it needs to look at date, time and skill.
    I have attached my sheet. the formula would need to go in the green box.
    It needs to look at the time (Column A), the date which Cell A2 and the skill which is cell CU1
    It needs to look at the tab Week 1 and grab the data if there is any, If it does not find any data, I need it to leave the cell blank.

    I looked at VLOOKUP, if statements and Index match. I am not overly familiar with index match, but by the looks of it; it may be my solution???

    Any help would be greatly appreciated.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Lookup Multiple Criteria using Index-Match in VBA
    By ykobure in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-21-2015, 01:41 AM
  2. Index Match To return a Hyperlink to the internet from data dump
    By eaflynn in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-02-2015, 11:21 AM
  3. Need an array possibly INDEX/MATCH formula with multiple lookup criteria.
    By TheClaw2323 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-25-2015, 09:59 AM
  4. Replies: 6
    Last Post: 04-30-2014, 02:42 AM
  5. LOOKUP with Multiple Criteria (ARRAY INDEX and MATCH)
    By snowktt in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-14-2014, 02:24 AM
  6. Multiple Criteria Lookup/Match/Index
    By Kasz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-15-2011, 09:30 AM
  7. Replies: 3
    Last Post: 07-11-2009, 02:58 PM

Tags for this Thread

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