Hi Steven,

Instead of using the names column directly from your imported data in
Sheet2, you would need to use an alias where the name gets translated
into one which you are bound to recognise in your shorter list.

To begin with, then, you need to build up an alias table - you could
copy your list of names for the 192 players to another sheet (say
Sheet3) in column B. In column A of this sheet you can have several
variations of each name, as indicated above with Pujols, Albert, so
your list might grow, let us say to row 600 - your alias table is thus
Sheet3!A$2:B$600.

Now, when you import your table of 2000 player's statistics into
Sheet2, you need to insert a new column B, and this is where you can
change the name in the imported table with the name in your alias table
(assuming the names are in column A) - put this formula in cell B2:

=IF(ISNA(VLOOKUP(A2,Sheet3!A$2:B$600,2,0)),A2,VLOO KUP(A2,Sheet3!A$2:B$600,2,0))

This will give you the alias name from your table if the name in the
imported table is found there, otherwise you will just have the
imported name.

Now you need to change the other VLOOKUP formulae in Sheet1 to look at
the name in column B of Sheet2 and not column A. The easiest way to
change these is to highlight the columns in Sheet1 with these formulae
in and use Find & Replace (CTRL-H). I had given you this formula in my
second posting:

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

so assuming you are using something similar you will need to:

Find: Sheet2!$A
Replace With: Sheet2!$B

That should do it. Hope it helps.

Pete