+ Reply to Thread
Results 1 to 4 of 4

INDEX MATCH MATCH/OFFSET MATCH MATCH with named ranges

  1. #1
    Forum Contributor
    Join Date
    05-20-2008
    Location
    England
    MS-Off Ver
    Office 365
    Posts
    136

    INDEX MATCH MATCH/OFFSET MATCH MATCH with named ranges

    I have a workbook with a lot of tables that have all been named.
    I am trying to do a lookup for data within whichever table the user has selected.
    I cannot therefore specify the MATCH array as that will change depending which table I need to look up from. I thought I may be able to use OFFSET MATCH MATCH but am having trouble getting that to work also (getting #VALUE error)

    I have tried to attach a sample of what I am working on but am struggling to put into words exactly what it is I am after so please ask questions, as many as needed!

    TIA Andrew
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    02-05-2013
    Location
    Jakarta, Indonesia
    MS-Off Ver
    Excel 2010
    Posts
    563

    Re: INDEX MATCH MATCH/OFFSET MATCH MATCH with named ranges

    May be like this:

    Formula on H1, copy down and to the right as far as you need

    Please Login or Register  to view this content.
    Click (*) if you received helpful response.

    Regards,
    David

  3. #3
    Forum Contributor
    Join Date
    05-20-2008
    Location
    England
    MS-Off Ver
    Office 365
    Posts
    136

    Re: INDEX MATCH MATCH/OFFSET MATCH MATCH with named ranges

    I think I may have found an easier way using a simple lookup for this bit but of course it's never simple is it.
    I have reattached what I have tried but it isn't working properly. Can anyone spot the (probably glaring) error I have made?

    In the second row all but the last option should be ticked. The first row is correct.
    Attached Files Attached Files

  4. #4
    Valued Forum Contributor
    Join Date
    02-05-2013
    Location
    Jakarta, Indonesia
    MS-Off Ver
    Excel 2010
    Posts
    563

    Re: INDEX MATCH MATCH/OFFSET MATCH MATCH with named ranges

    I don't see the error, your formula working OK.

    it's looking on D3 (1.670) on table Autograph FreeFrame and on the column Drivewear which the value are 0 (or X)

+ 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] INDEX & MATCH vs OFFSET & MATCH
    By andrewc in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-22-2013, 01:26 PM
  2. [SOLVED] index match with row information offset from the match cell
    By smls in forum Excel General
    Replies: 7
    Last Post: 08-30-2012, 09:48 AM
  3. Replies: 2
    Last Post: 03-16-2012, 12:03 PM
  4. Replies: 5
    Last Post: 02-29-2012, 08:51 PM
  5. Named Ranges and INDEX/MATCH
    By jasoncw in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-19-2007, 09:33 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