IF SEARCH Formulas with multiple condition

[adiacal7]

Hi mate I have some data as below


[TABLE="width: 169"]
<tbody>[TR]
[TD]Orange Juice[/TD]
[TD]Orange[/TD]
[/TR]
[TR]
[TD]Add Mango Jam[/TD]
[TD="align: center"]#VALUE![/TD]
[/TR]
[TR]
[TD]Filled up Coffe[/TD]
[TD="align: center"]#VALUE![/TD]
[/TR]
[TR]
[TD]Maybe repost[/TD]
[TD="align: center"]#VALUE![/TD]
[/TR]
</tbody>[/TABLE]

and I want to Search some word with some logic as below

=IF(SEARCH("Orange",B2),"Orange",IF(SEARCH("Mango",B2),"Mango",IF(SEARCH("Coffe",B2),"Coffe",IF(SEARCH("Repost",B2),"repost","Null"))))

I try it but it seems error value

Could someone help me please

 

[Aladin Akyurek]

In C2 enter and copy down:

=IFERROR(LOOKUP(9.99999999999999E+307,SEARCH({"coffee","mango","orange"},$B2),{"coffee","mango","orange"}),"null")

 

[adiacal7]

WOW thanks mate it work,, Can I know What measning of 9.99999999999999E+307 I don't have ideas with that

 

[Aladin Akyurek]

WOW thanks mate it work,,

You are welcome.

Can I know What measning of 9.99999999999999E+307 I don't have ideas with that

See:

1. https://www.mrexcel.com/forum/excel-questions/102091-9-9999999-a.html
2. https://www.mrexcel.com/forum/excel-questions/724843-there-case-sensitive-vlookup.html#post3568323