I'm trying to create a formula in a google sheet to find the value in the C column where the value in the A column is equal to the value in the E column.
E.g. Column E = 1 in Row 9-16 and Column A = 1 in row 2, therefore, show what's in Column C row 2
Column E = 2 in Row 17-24 and Column A = 2 in row 3, therefore, show what's in Column C row 3