As the title states:

I would like to return the average of a number of cells in a column, but only the cells that are next to a cell in a previous column, that displays a 1.

My explanation is terrible, but the following example displays how simple the actual problem is:

Question.xlsx

I was thinking of using VLOOKUP() in combination with AVERAGE() but am having difficulties.

Cheers