It is always easier to help and test possible solutions if we could work with your actual file. Perhaps you could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. Include a detailed explanation of what you would like to do referring to specific cells and worksheets. If the workbook contains confidential information, you could replace it with generic data.
If you look down in the N column, theres a player there called Jones, Louis, he shouldn't be there, it should be Amos, Danny. Whats happened is is that its looked for the first person with that rating & found him. I want it to look at the position which is in n2 so it finds the correct player, the one with the rating who plays in that particular position.