I have a formula that is referencing another sheet, and I would like a way to copy this formula in column "Rating 1"
=IFERROR(INDEX({Rating_Avg_Selection}, 2), "No Data")
in the same row to the right (next column), and reference the next number within the formula, which will point to the correct row where the data resides. The formula above is referencing "2" and when I drag this to the next column to the right, I want it to increment to "3" like this example in column "Rating 2"
=IFERROR(INDEX({Rating_Avg_Selection}, 3), "No Data")
This is an example row I have in my worksheet, and I have numerous rows that I will have to update manually if there is no workaround (OR hopefully there is a way to update my formula)
Thank you in advance.