Hi,

I have this situation, that I have process lead time results from pieces going trough process.

A B
Value Week
5 44
10 45
6 48
5 49
9 46
1 48
3 50
9 49
2 49
6 49
4 50

I want to return an average from column A values from specific week. For example for week 49, it should return 5,5. ((6+2+9+5)/4)

From what I understand, The VLOOKUP function cant handle multiple values. I think I should combine INDEX, MATCH and AVERAGE functions but how?


I'd be really thankful if someone has a solution for this.