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?
Bookmarks