+ Reply to Thread
Results 1 to 2 of 2

Index Match Question

  1. #1
    Registered User
    Join Date
    01-25-2013
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    13

    Index Match Question

    Happy Friday All,

    I have a spreadsheet with names and claim types. I want to populate a 3rd column with only names that match specific claims types (see attached). Using the index-match function gets me as far as one cell, then repeats itself when copying down [using =index(A:A,match(G1,B:B,0))]

    Is there a way to change the formula so it displays the next name down the line with the same claim type? I.e., cell E3 should read "Name8", E4 reads "Name9", E5 reads "Name15" and so forth?
    Attached Files Attached Files

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,453

    Re: Index Match Question

    Try
    Please Login or Register  to view this content.
    entered as an array formula with Ctrl+Shift+Enter and pull down as needed

+ 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