|Website 1||Website 2|
|Man Utd||Newcastle United|
|Newcastle Utd||Leicester City|
|Tottenham||West Ham United|
|West Ham||Manchester United|
I have a list of football teams from two different websites, and I want to match each team up with the it's team from the other website. I would normally use a VLOOKUP, but as the the teams are not identical that would not work. If I use the 'TRUE' option in the range lookup for VLOOKUP this does not work either, any suggestions please?