You can use VLOOKUP( ) for this. The larger table of 2000 players is
searched for a unique field, such as player number or player ID. This
should be the first field in the table. You could use a name, as long
as this is unique (no duplicates).

In your own smaller table of 192 players you would also have a player
ID column - suppose this is column A in Sheet1, and the larger table
occupies A2:M2001 in Sheet2. Assume the first player ID is in A2 of
Sheet1, then this formula in B2:

=VLOOKUP($A2,Sheet2!A$2:M$2001,COLUMN(),0)

would give you the data from the second column of the larger table for
the player in row 2 of your table (assuming there is a match - you will
get #N/A otherwise). If you want to derive the other statistics for
that player, copy the formula out to M2. You could then copy cells
B2:M2 down to row 193 to return the information for all of your 192
players.

You could then fix the data by highlighting B2:M193, clicking <copy
then Edit | Paste Special | Values (check) OK then <Esc, and this will
allow you to delete Sheet2 and retain the data for your smaller table.

Hope this helps.

Pete