+ Reply to Thread
Results 1 to 2 of 2

Cancel posting

  1. #1
    Registered User
    Join Date
    02-24-2012
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    1

    Cancel posting

    I created an alternative way for the user to capture the data. I may well return to trying to resolve the multiple criteria, index, match but for now I am afraid the time has passed.


    Original post

    I am attempting to create a index match across multiple sheets in a single workbook, where there are 3 criteria to match based on a source document and the return value is a cell reference:
    I can get it to work when I write the formula for the single sheet look up and is is as follows;

    =IF(ISERROR(MATCH($A16,'Day1'!$A:$A,0)),"no",INDEX('Day1'!$M:$M,MATCH(All!$C16,'Day1'!$D:$D,0)))

    This works I want to reference this across all the sheets at one time to return the the values as is, so I created a list with the tab headings on and called it mysheet and then have tried to insert it into the formula using the indirect function but am failing to identify the exact reason it fails;

    =IF(ISERROR(MATCH($A17,indirect(""'&Mysheets&"'!$A:$A,0)),"no",INDEX(Indirect(""'&Mysheets"'!$M:$M,MATCH(All!$C17,indirect(""'&Mysheets&"!$D:$D,0)))
    the error reference highlights the " " '

    I am now starting to doubt if this is possible.

    Thanks in advance to any replies.
    Last edited by Richard3; 03-02-2012 at 06:45 AM. Reason: no solution, out of time

  2. #2
    Forum Contributor darknation144's Avatar
    Join Date
    01-24-2012
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    552

    Re: Named range in index match across multiple sheets

    Removed by user
    Last edited by darknation144; 02-24-2012 at 12:52 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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