Search two cells, display one of them

[marshy3300]

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!

 

[DanteAmor]

I hope this is what you need:

varios 09jul2020.xlsm
	E	F	G
2	Melb	Adjustment	Melb
3	Adjustment	Per	Per
Sheet2

Cell Formulas
Range	Formula
G2:G3	G2	=IF(E2<>"Adjustment",E2,IF(F2<>"Adjustment",F2,""))

 

[marshy3300]

Yep. Easy

Thanks DanteAmor

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.