+ Reply to Thread
Results 1 to 6 of 6

Index with Nested Match Function Help

  1. 08-29-2015, 05:45 PM #1
    T86157
    T86157 is offline
    Forum Contributor
    Join Date
    05-17-2012
    Location
    CA, USA
    MS-Off Ver
    Microsoft Excel for Microsoft 365
    Posts
    163

    Index with Nested Match Function Help

    How can I reference a Named range or table in VBA rather than 
    Please Login or Register  to view this content.
    ?
    Last edited by T86157; 08-29-2015 at 05:53 PM.
    Reply With QuoteRegister To Reply
  2. 08-29-2015, 06:03 PM #2
    TMS
    TMS is online now
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,420

    Re: Index with Nested Match Function Help

    Some examples:

    Please Login or Register  to view this content.

    Immediate Window:

    Please Login or Register  to view this content.

    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  3. 08-29-2015, 06:08 PM #3
    TMS
    TMS is online now
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,420

    Re: Index with Nested Match Function Help 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  4. 08-29-2015, 06:46 PM #4
    TMS
    TMS is online now
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,420

    Re: Index with Nested Match Function Help

    As this thread has been marked Solved, I take it you have been given an answer that resolves the problem?
    Reply With QuoteRegister To Reply
  5. 08-30-2015, 12:11 PM #5
    T86157
    T86157 is offline
    Forum Contributor
    Join Date
    05-17-2012
    Location
    CA, USA
    MS-Off Ver
    Microsoft Excel for Microsoft 365
    Posts
    163

    Re: Index with Nested Match Function Help

    Yes, thank you TMS. This worked out perfectly.
    Reply With QuoteRegister To Reply
  6. 08-30-2015, 12:43 PM #6
    TMS
    TMS is online now
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,420

    Re: Index with Nested Match Function Help

    You're welcome. Thanks for the rep.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Help Requested with Nested Small Function Inside Index/Match Formula
    By trandle in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-26-2015, 10:07 AM
  2. [SOLVED] Exclude Zero's from Min Function nested inside an index+Match... all within CELL funtion
    By clemsoncooz in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 08-05-2014, 05:16 PM
  3. [SOLVED] Nested IF Function problem, involving index/match
    By nonymous in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-11-2014, 12:03 PM
  4. [SOLVED] Nested INDIRECT in INDEX/MATCH function
    By xtort81 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-24-2014, 03:08 PM
  5. nested MATCH function within the INDEX function
    By thechoosenonesdream in forum Excel General
    Replies: 4
    Last Post: 10-25-2012, 03:55 PM
  6. Nested Match(index()) vs. Match() array formula.
    By GeneralDisarray in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-14-2011, 07:57 AM
  7. Nested Function using MATCH and/or INDEX
    By ExcelJunkie in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-26-2006, 03:54 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1