Forum Discussion
Excel- I want to make a search of value in a sequence
In a cell I have a value A5, in next cell I have a text A1-A10 (which has the meaning of A1, A2, A3, A4......A10). I want to check and confirm That A5 present in this sequence. Is there any formula?
1 Reply
You question is ambigous. What is the exact text in your 2nd cell?
The way I understand it's "A1, A2, A3, A4, A5, A6, A7, A8, A9, A10".
If that's correct, you can use the SEARCH function.
So, if cell A1 has the text "A5" and cell A2 has the text "A1, A2, A3..." as shown above, you can use the following function in a 3rd cell.
=SEARCH(A1, A2)
