Hi there,
It's not going to be easy to do this while your data are in their current format!
The "space" character you're using between the names in Column B is not the same as the "space" character you're using in Column E. They both look the same on the screen but if you insert the following formula (Antonio Brown) in any cell:
the result will be FALSE. If you delete the Space character in Cell B3 and retype it as a "normal" space (i.e. using the SpaceBar) the formula will evaluate to TRUE.
I've checked the above situation for a few player names and all of them seem to show the same problem.
If you can ensure that the space characters used in Columns B and E are consistent, there might be some chance of achieving what you want using LOOKUP and MATCH formulas.
Hope this helps - please let me know how you get on.
Regards,
Greg M
Bookmarks