Searching multiple cells in a column, splitting on a " vs " string and doing a bit of Math

Hi all,

Quiet day at the office so I am playing with excel trying to create a spreadsheet for a game I play every year with a few friends. Previously the spreadsheet has been largely manual but I decided to automate as much as possible.

Here's my dilemma. (See attachment)

Sheet 1 contains a list of fixtures and results.

Sheet 2 contains the league table.

So I need to search for a team in sheet A, their relevant result and award the points as necessary, 3 for a win, 1 for a draw, 0 for a loss.

I've tried LEFT, FIND and many other commands to split on the " vs " but have had no joy, I am wondering if I'm into the realms of VBA here?

Thanks

Dave