suggest second argument make it absolute so that the formula can be used any other value in column C by copying C2
the reference values of C2 and similar should be in the first column of second argument reference range.
the second argument is 1 that means same as c2 value which is in column I (It is not value in column J in that case the argument is 2 and not 1. in offset it is one step to the right but in vlookup the columns are counted from the first column in the reference range(that is second argument I:L in your case)
please again read vlookup.
perhaps your data sheet in sport sheet is different. copy a small portion in your replly and the value of C2 in the first sheet where formula is paraked