I have an excel with a huge database of soccer games. The columns are: "date", "stadium", "local_team", "local_score", "away_score", "away_team".
The problem is that I can't create a list box or a search engine to work within the columns "local_team" and "away team" as they are two separate columns that contain the same data. Each row is a game and sometimes the team in the column "local_team" apperas too in the column"away_team".
The goal will beto choose the "team x" from a list and show me the team in both columns "home_team" and "away_team".
thanks
