returning elo calculations from one sheet to another

[croissantist]

Hi everyone,

I am quite new to excel and have stumbled upon a problem. Namely I have a document where on one sheet (see 1.png) I have a table with teams and their elo values, while on the other sheet (see 2.png) I have data from a certain period that is then converted to an elo change for a speficic team within the period provided covered by the data. Most of it is constructed using the lookup function, so nothing really fancy.

So, on the second sheet (2) I have to enter a team name on to one cell (G4) and it returns the elo change values in G7. Given that the G4 value is never constant, since I need to change it for each team, I have had to enter team name and paste the elo change value to the 1st sheet manually for each team. I am wondering if it would be possible for the document to calculate the elo change automatically and return the elo change value to the first sheet for each team somehow. Would there be a formula for that or is the only realistic alternative to have a separate E-AH range for each team?

I attached pics of both sheets as well. I hope someone can help me!
All the best!