I'm working with a spreadsheet that uses Index and Match. After reading help and searching this forum I understand Index tells the cell to go to a data range and return the contents of row x and column y. If you put Match in for the column_num the formula looks for a match and finds the relative row number. In my spreadsheet it's looking for an exact match.
My question is with the last item in the syntax for Index. In cell C12 the last item in the syntax for the Index formula is +1:
=INDEX($R12:$FM12,MATCH(B$10,$R$10:$FM$10,0)+1)
Does this mean find the match and go over +1 columns?
Sample workbook attached.
Catherine
Bookmarks