Help creating a new column based on column queries

[jamieham]

Im trying to create a new column (Opposition) based on a query that looks at the Team column and the Home & Away team and adds the Opposition based on what the Team column lists.

Team	Home Team	Away Team	Opposition
Australia	Australia	Georgia
Georgia	Australia	Georgia
England	England	Australia
Australia	England	Australia
France	Scotland	France
Scotland	Scotland	France

[Greg_Deckler · Accepted solution]

@jamieham -

Perhaps:

Opposition = IF([Team] = [Home Team],[Away Team],[Home Team])