ms excel, lookup word from a cell Solved/Closed

Question

A	         B	                                                                   C
1	C287198	MARIQ BLDG MATERIAL TRDG C287785	           C287785
2	C287786	GEN TRDG,C287198	                                           C287198
3	C287792	NAMARIQ BLDG C287786 MATERIAL	
4	C287785	NAMARIQ BLDG RDG,C287786	

I need to find a word from a sentence in a cell and if it is there in that cell, it should come to cell C,  like i need to find in which cell contain that word from a column like     
want to find A1 in the whole B column, if any cell contains so. the word should come in the column against the B column. pleas help

Mazzaropi · Answer

Muniz Reza, Good Morning. 
 
Do you tried to use the SEARCH function ?

..........A...................B..................................................................
1.....CODE........SENTENCE...........................................................
2...C287198.....MARIQ BLDG MATERIAL TRDG C287785 C287785 

=SEARCH(A1,B1)
If the result isn't error then it found a code in the sentence.

You can deal with this case like this:
C1 --> =IF(ISERROR(SEARCH(A1,B1)),"",A1)

I hope it helps you.
Tell us if it worked for you.

Muniz Reza · Answer

Thank you for your help.
Still i am having a prob, I need to search in the entire B column whether this A1(C287198) exists in which cell and it should come 'right C cell" against where it exists...

Please advise.

Ms excel, lookup word from a cell

2 responses

Similar discussions

Subscribe To Our Newsletter!