Ms excel, lookup word from a cell [Solved/Closed]

Report
Posts
6
Registration date
Saturday September 14, 2013
Status
Member
Last seen
November 10, 2013
-
Posts
1843
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 29, 2020
-
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

Posts
1843
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 29, 2020
136
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.
Posts
6
Registration date
Saturday September 14, 2013
Status
Member
Last seen
November 10, 2013

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.
Posts
1843
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 29, 2020
136
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.