marshy3300
Board Regular
- Joined
- Aug 17, 2014
- Messages
- 59
Hi team,
Should be easy but i'm stumped.
In E2 I'm either going to have Melb, Bris, Syd, Per (one Capital) or "Adjustment". In F2 I'm either going to have Melb, Bris, Syd, Per (one Capital) or "Adjustment"...
So
E2 and F2 will either Melb / Adjustment or Adjustment / Melb. Lets say E2 is Melb. F2 is adjustment
E3 and F3 either Adjustment / Per or Per / Adjustment. Lets say E3 is Adjustment and F3 is Per
In G2 i want to search E2 and F2 for the Capital and display whichever cell contains the Capital. In the first example it would display E2. Second Example it would display F3
Thanks in advance!
Should be easy but i'm stumped.
In E2 I'm either going to have Melb, Bris, Syd, Per (one Capital) or "Adjustment". In F2 I'm either going to have Melb, Bris, Syd, Per (one Capital) or "Adjustment"...
So
E2 and F2 will either Melb / Adjustment or Adjustment / Melb. Lets say E2 is Melb. F2 is adjustment
E3 and F3 either Adjustment / Per or Per / Adjustment. Lets say E3 is Adjustment and F3 is Per
In G2 i want to search E2 and F2 for the Capital and display whichever cell contains the Capital. In the first example it would display E2. Second Example it would display F3
Thanks in advance!