My problem: I am a football team manager. I have 2 workbooks, 1 has top
appearances for each player (column 1 shows their overall position, column 2
shows their name, column 3 shows total appearances) the other has top
goalscorers (column 1 shows their overall position, column 2 shows their
name, column 3 shows their percentage of goals scored per game using a simple
formula that divides the number of goals scored by...column 4 which shows the
number of appearances.)

I am trying to get a formula that will automatically update the number of
appearances in column 4 on my top goalscorers workbook whenever i update my
top appearances for a particular player, whilst ensuring that a player's
position in the top appearances can change.

I have tried using the ADDRESS function, as well as VLOOKUP and MATCH and
still can't get anywhere. help help help!!!!!!!!!!