Search for a word in a cell
Solved
nonossov
Posted messages
638
Status
Membre
-
Sachex -
Sachex -
Hello my friends,
I need your help to find a word in a cell and give its corresponding value; for example, cell A1 contains the words Smart vision technology, and cell B1 contains 100,
I want to know the formula I can use to search for the word vision in A1 and get the corresponding value.
For your information, I used this formula to find the corresponding value of a single word; now I need to find a word in a phrase, for example.
=+VLOOKUP(A1,Sheet2!$A:$B,2,0)
Thank you in advance, my friends!
Configuration: Windows XP / Chrome 48.4.2564.88
I need your help to find a word in a cell and give its corresponding value; for example, cell A1 contains the words Smart vision technology, and cell B1 contains 100,
I want to know the formula I can use to search for the word vision in A1 and get the corresponding value.
For your information, I used this formula to find the corresponding value of a single word; now I need to find a word in a phrase, for example.
=+VLOOKUP(A1,Sheet2!$A:$B,2,0)
Thank you in advance, my friends!
Configuration: Windows XP / Chrome 48.4.2564.88
Yes, this formula can be useful to me, but can we search for a word without writing it in the formula? For example, in the same formula:
=IF(COUNTIF(A1;"A2");B1;"")
can we search for the word written in A2 instead of writing it in the formula??
Thank you very much.
=IF(ISERROR(SEARCH(A2,A1));"";B1)
It looks for A2 in A1; if yes, then B1, otherwise nothing.
There are certainly other methods, maybe this one will suit you better.
Thank you!! The use of stars is excellent!!