TEAM Ave Points Home Ave Road Ave Ave Allow Home Allow Road Allow Home Away AVE PTS OFF PTS DEF PTS O/U
Boston 102.82 103.42 102.22 98.31 98.54 98.09 Brooklyn Boston
Brooklyn 105.42 104.88 105.96 108.79 107.04 110.54
New York 105.12 107.54 102.69 106.03 102.71 109.35


Call the Team Column Colum A and the O/U Column M. The Home column(H) and the Away column(I) will always have a Team from column(A) in those columns. I need the ave pts column(J) to add the Ave Points Column(B) that are tied to the team name in the Team column(A).

Also, for column OFF PTS Column(K) I need it to add the column Home Ave(C) for the Team in the Home Column(H)(which matches a team name in the Team Column(A) with the Road Ave Column(D) for the Team in the Away Column(I)(which matches a team name in the Team Column(A)

My goal is to be able to mix and match any home and away team in columns H and I, and have the ave pts / off pts / def pts populate into those columns based off of their averages in B, C, D, E, F, and G.

Examples - Ave Pts column(J2) needs to add the Home team Column(H)(which will always come from the Team Column(A) with what that teams ave points is in column(B) with what the Away team Column(I)(which will always come from the Team Column(A) with what that teams ave points is in column(B).

This is very complicated to me, and I'm sure it is confusing, so let me know if you need clarification on anything. I'm a noob and don't know much. Hope this is possible.

Thank you for any and all help!