Related:
- Ms excel, lookup word from a cell
- Excel lookup 2 cells to match in 2 rows. ✓ - Forum - Excel
- Excel find word in series of cells and add ✓ - Forum - Word
- Excel find word in cell ✓ - Forum - Word
- Excel push value to another cell - How-To - Excel
- Excel copy data from one cell to another if a condition is met - Forum - Excel
2 replies
Mazzaropi
- Posts
- 1843
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- October 29, 2020
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
- 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.
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
- Posts
- 1843
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- October 29, 2020
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.
