Results 1 to 5 of 5

index and match multiple columns on two different sheets

Threaded View

  1. #1
    Registered User
    Join Date
    04-19-2013
    Location
    Woodchester
    MS-Off Ver
    Excel 2007
    Posts
    8

    index and match multiple columns on two different sheets

    Hi,

    I've got a problem where I am trying to return a value if two criteria from one table match two from another.

    I have included a example of my issue.

    =INDEX(Time!D:D,MATCH(Data!A2,Time!A:A,0)*AND(MATCH(Data!C2,Time!C:C,0)))

    I have had a look around lots of forums but cant get my head around what is wrong with my formula


    Thanks in advance of any help
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. INDEX and MATCH(?) combined with SUM across multiple sheets
    By jusmightbeokay in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-14-2014, 06:14 AM
  2. Vlookup (or index/match) with multiple criteria over multiple sheets
    By Groovicles in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-18-2013, 01:56 PM
  3. Multiple Sheets Match & Index filtering by sheets
    By ijulian in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-24-2012, 01:49 PM
  4. index match from multiple sheets
    By avk in forum Excel General
    Replies: 4
    Last Post: 10-13-2011, 04:30 PM
  5. Replies: 2
    Last Post: 06-29-2011, 01:36 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