Ms excel, lookup word from a cell

Solved/Closed
Muniz Reza
Posts
6
Registration date
Saturday September 14, 2013
Status
Member
Last seen
November 10, 2013
- Sep 14, 2013 at 06:37 AM
Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
- Sep 14, 2013 at 12:52 PM
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

2 replies

Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
147
Sep 14, 2013 at 09:57 AM
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.
0
Muniz Reza
Posts
6
Registration date
Saturday September 14, 2013
Status
Member
Last seen
November 10, 2013

Sep 14, 2013 at 10:19 AM
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.
0
Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
147
Sep 14, 2013 at 12:52 PM
Muniz Reza, Good afternoon.

I did an example to you. https://www.cjoint.com/c/CIosYHEu9Q0

Take a look at it and tell us if is it what you desire.

I hope it helps.
0