Website 1 | Website 2 |
Man Utd | Newcastle United |
Newcastle Utd | Leicester City |
Leicester | Tottenham Hotspurs |
Tottenham | West Ham United |
West Ham | Manchester United |
<tbody>
</tbody>
Hi,
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?
Thanks