Allowing a formula that references another sheet, and to be copied via the drag function 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 dragged this to the next column to the right, it should increment to "3" like this example in column "Rating 2"
=IFERROR(INDEX({Rating_Avg_Selection}, 3), "No Data")
This is an example of the row in a worksheet
So when =IFERROR(INDEX({Rating_Avg_Selection}, 2), "No Data") is dragged to the next column, it will increment to =IFERROR(INDEX({Rating_Avg_Selection}, 3), "No Data") and continue increasing the "Number" within the formula.
