IF isnumber and search funtion

[RAJESH1960]

Please help me to correct this formula. The cells marked Yellow in column B should display Contra in column G. I am getting correct answer in some cells, but not all. I have used this function: =IF(ISNUMBER(SEARCH($F$2:$F$5,B2)),E2,D2)

 

[RAJESH1960]

Two things.
1) you are not using the formula I suggested.
2) your expected answers make absolutely no sense whatsoever. Only rows 17 & 18 should be col C the rest should all be contra.

Fluff I got it right. Problem is solved
=IF(OR(COUNT(SEARCH($D$2,B2),SEARCH($D$3,B2),SEARCH($D$4,B2),SEARCH($D$5,B2))>1,IFERROR(SEARCH($D$6,B2)>0,0)),"Contra",C2)