Results 1 to 2 of 2

Index Match Question

Threaded View

  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

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