+ Reply to Thread
Results 1 to 2 of 2

Index/Match with 3 criteria

  1. #1
    Forum Contributor
    Join Date
    02-24-2011
    Location
    Los Angeles, CA
    MS-Off Ver
    Office 2010
    Posts
    164

    Index/Match with 3 criteria

    I have a file where I'm trying to pull in the column "Work Type" from a table onto another tab. It is suppose to be matching the date in cell $B$4, the From time in column B5, and the To time in column C5 to the table in the "Meeting Agenda" tab. I have it entered with a Cntl + Shift + Enter, but it's coming up with an error. I found two different articles on Google, and I thought I followed them and modified them exactly, but it's still not working.

    The formula is
    Please Login or Register  to view this content.
    Can anyone tell me what I have wrong with this formula. I have it attached for your review...
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    02-24-2011
    Location
    Los Angeles, CA
    MS-Off Ver
    Office 2010
    Posts
    164

    Re: Index/Match with 3 criteria

    Never mind all! I had saved the file and closed it for a bit of time. When I went back into it, it worked fine.

+ 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. Replies: 16
    Last Post: 01-05-2018, 11:04 PM
  2. Need help in Index, Match usage to match multiple criteria in sum function
    By Summer0830 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-26-2017, 02:47 AM
  3. VBA Code for Index/Match/Match to input into excel based on 2 criteria inside form
    By Carl Fisher in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-22-2017, 12:11 PM
  4. [SOLVED] Index and Two Match Criteria- meeting both criteria (need help to repair formula)
    By OilAndGasMan1984 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-27-2017, 10:56 PM
  5. [SOLVED] Combining 3 Formulas: Return all Names that Match Criteria Using Index/Match
    By bchilme in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 09-29-2014, 09:28 AM
  6. Replies: 2
    Last Post: 09-27-2014, 04:34 PM
  7. Replies: 6
    Last Post: 04-30-2014, 02:42 AM

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