I am working on a project. I need partial part of the result derived from a formula, to keep changing based on the sourced cell value.
for e.g. A1 is the sourced cell. It has the value as "Team A".
In B1, the result should occur as "The Game is won by Team A"...