returning elo calculations from one sheet to another

croissantist

New Member
Joined
Feb 3, 2020
Messages
1
Office Version
365
Platform
Windows
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!
 

Attachments

Some videos you may like

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

Watch MrExcel Video

Forum statistics

Threads
1,090,459
Messages
5,414,647
Members
403,540
Latest member
mmorejon1215

This Week's Hot Topics

Top