Trying to copy formulas but confused with RELATIVE AND ABSOLUTE !

Hi all.

If you please look at attached file, I am trying to populate the "Player's Form" sheet. I have done and tested the first row, R2. It's what I want but I'm having problems copying and pasting subsequent rows. All that needs to change on each row is the column - I hope you see what I mean .

I have done the first few manually, but there must be an easier way! Thanks for any help

EDIT - I have tried using find $G and replace with $H in formulas but it replaces all

This going to be tough to do seeing as you have the names repeated.

I have made a start, using this....
=OFFSET(Payments!$F$6,MATCH('Player''s Form'!C$1,Payments!$F$6:$F$500,0)-1,MATCH('Player''s Form'!$A2,Payments!$G$3:$AX$3,0))

If you just want to pull in the value for each "match", then that will do it for you, im not sure what you are trying to sum though?

edit: if you just want to pull the single value, then maybe this instead...
=INDEX(Payments!$F$3:$DN$299,MATCH('Player''s Form'!C$1,Payments!$F$3:$F$299,0),MATCH('Player''s Form'!$A2,Payments!$F$3:$DN$3,0))

This thread is marked SOLVED, is that case or does it need to be marked UNSOLVED?