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 assume they are differing renderings of the same team name?
For me, the solution would to be to conduct a 'wildcard' enabled search
= XLOOKUP(
"*"&Name&"*",
TeamName,
Pts,
"Not found",
2)where the final 2 introduces the wildcard setting. Without XLOOKUP, I am guessing; perhaps
= INDEX(
Pts,
MATCH(
TRUE,
ISNUMBER(FIND(Name, TeamName)),
0)
)but I am not the ideal person to answer non-365 questions.
- Both within XLOOKUP and the xxxIFS family of functions a "?" and a "*" can have special significance matching a single character or multiple characters respectively. That allows a search to be conducted for a substring occurring within the target string.
