Search from multiple outcomes and convert.

[Davebro]

I have football matches in Col. A. Predictions in Col.B. In Col. C i need the prediction (B) to be converted to possible outcomes.
I have been using IF(SEARCH whch has worked well if only two choices H or A but now there are multiple choices I am somewhat lost how to comvert them all.
This is useful for analysis later.

Teams	Prediction
Mongolia v Lebanon	The Draw	D				Possible Outcomes
Japan v El Salvador	Over 2.5 Goals	O 2.5			Col B	H
Greece v Republic of Ireland	Republic of Ireland	A			The Draw	D
Poland v Germany	Under 2.5 Goals	U 2.5			Col B	A
Azerbaijan v Estonia	Estonia	A			Under 0.5 Goals	U .5
Norway v Scotland	Over 1.5 Goals	O 1.5			Over 0.5 Goals	O .5
Portugal v Bosnia	Portugal	H			Under 1.5 Goals	U 1.5
Sport Recife v Vila Nova	Vila Nova	A			Over 1.5 Goals	O 1.5
Armenia v Latvia	Under 1.5 Goals	U 1.5			Under 2.5 Goals	U 2.5
					Over 2.5 Goals	O 2.5

 

[Fluff]

How about

Fluff.xlsm
	A	B	C	D	E	F	G
1	Teams	Prediction
2	Mongolia v Lebanon	The Draw	D	D			Possible Outcomes
3	Japan v El Salvador	Over 2.5 Goals	O 2.5	O 2.5		Col B	H
4	Greece v Republic of Ireland	Republic of Ireland	A	A		The Draw	D
5	Poland v Germany	Under 2.5 Goals	U 2.5	U 2.5		Col B	A
6	Azerbaijan v Estonia	Estonia	A	A		Under 0.5 Goals	U .5
7	Norway v Scotland	Over 1.5 Goals	O 1.5	O 1.5		Over 0.5 Goals	O .5
8	Portugal v Bosnia	Portugal	H	H		Under 1.5 Goals	U 1.5
9	Sport Recife v Vila Nova	Vila Nova	A	A		Over 1.5 Goals	O 1.5
10	Armenia v Latvia	Under 1.5 Goals	U 1.5	U 1.5		Under 2.5 Goals	U 2.5
11						Over 2.5 Goals	O 2.5
Master

Cell Formulas
Range	Formula
D2:D10	D2	=IFNA(INDEX($G$3:$G$11,MATCH(B2,$F$3:$F$11,0)),IF(SEARCH(B2,A2)=1,"H","A"))

 

[Davebro]

How about

Fluff.xlsm
	A	B	C	D	E	F	G
1	Teams	Prediction
2	Mongolia v Lebanon	The Draw	D	D			Possible Outcomes
3	Japan v El Salvador	Over 2.5 Goals	O 2.5	O 2.5		Col B	H
4	Greece v Republic of Ireland	Republic of Ireland	A	A		The Draw	D
5	Poland v Germany	Under 2.5 Goals	U 2.5	U 2.5		Col B	A
6	Azerbaijan v Estonia	Estonia	A	A		Under 0.5 Goals	U .5
7	Norway v Scotland	Over 1.5 Goals	O 1.5	O 1.5		Over 0.5 Goals	O .5
8	Portugal v Bosnia	Portugal	H	H		Under 1.5 Goals	U 1.5
9	Sport Recife v Vila Nova	Vila Nova	A	A		Over 1.5 Goals	O 1.5
10	Armenia v Latvia	Under 1.5 Goals	U 1.5	U 1.5		Under 2.5 Goals	U 2.5
11						Over 2.5 Goals	O 2.5
Master

Cell Formulas
Range	Formula
D2:D10	D2	=IFNA(INDEX($G$3:$G$11,MATCH(B2,$F$3:$F$11,0)),IF(SEARCH(B2,A2)=1,"H","A"))

Many thanks again, perfect, just I was looking for.

 

[Fluff]

You're welcome & thanks for the feedback.