Forum Discussion
Sports Betting
So I am made a sports betting model (very simple) and its more so just for fun. But I have been more and more interested in improving it. I recently started using power ratings found online from diff...
I can definitely understand how frustrating it must be to have to enter the same matchup multiple times due to naming inconsistencies across your data sources. . I'm not an expert in Excel, but have you considered using a formula like "IF" or "INDEX/MATCH" instead of VLOOKUP to match the team names across your different sources? That way, you could input the matchup once and have the formula do the rest of the work for you.
