Something like this to return Goals scored for a particular player:

=IF(($C5="A"),LOOKUP($A5,'Current Stats'!$A$1:$A$1000,'Current Stats'!$$D$1:$D$1000)," ")

Typing an "A" into the cells in column C is the manual switch I use, once I know a player is on the list, but there must be a way to only return an exact match and not something that's close to the lookup criteria.

Any help would be greatly appreciated.