Conditional formula based on a word in a line

[anmol786]

Sir

is that possible to put an output on a condition based on a word in a cell

Like :

Cell B4 has a line : i m too old to use this gun now

now D4 i want this formula

If cell B4 has a word : old put in D4 output 100 else 0000

how to be done that

find that in attached file

[benishiryo]

hi anmol. try:
=IF(COUNTIF(C4,"*arif*"),100,1000)

[anmol786]

Thanks a lot

just feel blessed to get solution

but what if i i want to use this formula with if or Condition

like if C4 has arif then put 100 or it it has anmol put 1000 but if it has awesome put 0

plz suggest

[samba_ravi]

=IFERROR(INDEX({100,1000,0},MATCH(TRUE,SEARCH({"arif","anmol","awesome"},A1)>0,0)),0)

[m_hassaan]

Guys - I know it was too hard to think about this solution but here you go with the solution to highlight certain word in cell
1) Open Excel Sheet
2) Insert Text Box
3) Move the text box to the word you want to highlight it
4) remove text box outline
5) fill the box color as you wish
6) reduce the box transparency so that your highlighted word appears

Your feedback is really matters!
BR,
Mohamed Hassaan From Egypt