IF SEARCH Formulas with multiple condition

[adiacal7]

Hi mate I have some data as below

Orange Juice	Orange
Add Mango Jam	#VALUE!
Filled up Coffe	#VALUE!
Maybe repost	#VALUE!

<tbody>
</tbody>

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