Results 1 to 6 of 6

Use OFFSET in INDEX MATCH MATCH

Threaded View

  1. 11-02-2016, 09:16 PM #1
    BRISBANEBOB
    BRISBANEBOB is offline
    Forum Contributor
    Join Date
    12-02-2008
    Location
    Brisbane
    MS-Off Ver
    2016
    Posts
    807

    Use OFFSET in INDEX MATCH MATCH

    I am trying to figure out how to return the second instance of a criteria in an array. The attached workbook explains it exactly. Any help appreciated.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« 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] vlookup to index/match or match/offset
    By scottiex in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-15-2015, 01:24 AM
  2. INDEX MATCH MATCH/OFFSET MATCH MATCH with named ranges
    By Andrew-Mark in forum Excel General
    Replies: 3
    Last Post: 02-27-2015, 10:56 PM
  3. [SOLVED] INDEX & MATCH vs OFFSET & MATCH
    By andrewc in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-22-2013, 01:26 PM
  4. Index match offset to get subsequent index values in a column
    By Andrew_Step in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2013, 02:55 PM
  5. Offset/Match vs. Index/Match
    By amartino44 in forum Excel General
    Replies: 5
    Last Post: 12-27-2012, 01:31 PM
  6. [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
  7. Match, Offset, Match, Index, Countif = VLOOKUP Handles Duplicates
    By dim06 in forum Excel General
    Replies: 2
    Last Post: 03-16-2012, 12:03 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