Ms excel, lookup word from a cell
Solved/Closed
Muniz Reza
Mazzaropi
- Posts
- 6
- Registration date
- Saturday September 14, 2013
- Status
- Member
- Last seen
- November 10, 2013
Mazzaropi
- Posts
- 1963
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- April 25, 2022
Related:
- Ms excel, lookup word from a cell
- Excel lookup specific text in cell ✓ - Forum - Word
- Excel lookup 2 cells to match in 2 rows. ✓ - Forum - Excel
- Excel find word in series of cells and add ✓ - Forum - Word
- Excel find a word in a cell and return value ✓ - Forum - Excel
- Excel conditional formatting if another cell contains specific text ✓ - Forum - Excel
2 replies
Mazzaropi
Sep 14, 2013 at 09:57 AM
- Posts
- 1963
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- April 25, 2022
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.
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
Sep 14, 2013 at 10:19 AM
- 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.
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.
Mazzaropi
Sep 14, 2013 at 12:52 PM
- Posts
- 1963
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- April 25, 2022
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.
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.