Need to change formula every week. Looking for easier way

[maybl8]

I hope I can explain this correctly.
I have a formula shown below that I have to change every week. I was looking for a way to make it easier to do.
This is the formula:

=IF($Games.$J$111="","",IF($Games.$J$111=$Games.$L$111,"T",IF($Games.$J$111<$Games.$L$111,"W","L")))

The 111 in the formula is a line number that changes each week. I have to manually change it for about 60 entries. I will know what the next number is for the line but was wondering if there was a way I could read something that would change the formula for me.
Right now I copy and paste the formula to the next location and copy and paste from the previous entry and then do a search and replace on the number.

[ajlittoz]

I which cell is this formula located? Your formula contains absolute references.

If the cell has always the same relative position to line “111”, use relative references (without the $ sign) and you’ll no longer need to update it.

PS: OS name, LO exact version, save format?

[maybl8]

Line
111 	1:00 pm	 New England Patriots	 New Orleans Saints
112	1:00 pm	 Seattle Seahawks	 Jacksonville Jaguars
113 	4:05 pm	 Tennessee Titans	 Las Vegas Raiders
114 	4:25 pm	 Cincinnati Bengals	 Green Bay Packers (L)
115 	4:25 pm	 San Francisco 49ers	 Tampa Bay Buccaneers
116 	8:20 pm	 Detroit Lions	 Kansas City Chiefs
 Mon Oct 13	7:15 pm	 Buffalo Bills	 Atlanta Falcons
117 	8:15 pm	 Chicago Bears	 Washington Commanders
			
Week 7			
               Date	Time (ET)	 Away Team	 Home Team
131      Thu Oct 17	8:15 pm	 Denver Broncos	 New Orleans Saints
132      Sun Oct 20	9:30 am	 New England Patriots	 Jacksonville Jaguars

This would be how the line numbers would be changed and I am referencing in the formula what line number the team corresponds to.

I am on Manjaro Linux. LO 25.8.1.1 using ods format.

[koyotak]

My example – admittedly quite complex, needs to be studied
00000_LO-CALC_sample_040103.ods (21.7 KB)
With =LET(), each otherwise multiple identical calculation is calculated and named only once, which reduces the change in the many row numbers to 1 and internally accesses the name assigned therein (not the cell).

[maybl8]

thanks I will take a look at these functions. I appreciate the guidance