Combine IF, VLOOKUP AND RIGHT

Hi all,
https://docs.google.com/spreadsheets...it?usp=sharing
My sheet is above

Please can someone guide me how to write a formula on the admin tab:

I want to write in J2:

IF I2 is blank (do nothing)
IF I2 has a value (is not blank) VLOOKUP the name in column A, which is also in column A on the latest game tab and return the score i.e 1-0 which will be after a ':' syumbol in column A on the latest game tab for the name in cell A2

=IF(I2<>"",VLOOKUP('Latest game'!A:A,RIGHT('Latest game'!A6))

Please can someone guide
me.

thank you!

Please post file on the forum as many contributors are not willing to access file-sharing platforms.

I looked at your file and it does not make sense: how are you looking up "Adam" vs "Chris" ?

=IF(I2<>"",RIGHT(VLOOKUP(A2,'Latest game'!A:B,2,0),1)

Team in A, results in B with A2=Name of interest ("Chris","Bob" etc)

You should (cannot) not have team and result in same cell