Forum Discussion
Solved
Search find in excel
This may be a basic question, but I have been looking for the way to find an answer for this over the past few days. Suppose sheet 1, ColumnA: 123 456 789 Then I have another sheet2, colu...
Twifoo , at least that's my understanding of the question. In this its' part.
You may try this formula in Sheet2!B1, copied down rows:
=INDEX(A:A,
MATCH(“*”&Sheet1!A1&”*”,
A:A,0)
The foregoing formula returns the first value in Column A that contains the value in Sheet1!A1.
=INDEX(A:A,
MATCH(“*”&Sheet1!A1&”*”,
A:A,0)
The foregoing formula returns the first value in Column A that contains the value in Sheet1!A1.
Twifoo , the only point the formula shall return result into column B of Sheet1 from A:A in Sheet2.
- Perhaps, I misunderstood the requirement. The formula should be in Sheet1!B1, copied down rows, which is:
=INDEX(Sheet2!A:A,
MATCH(“*”&A1&”*”,
Sheet2!A:A,0))Thanks.
This is absolutely the answer. One thing though, the cell must be in "text" format.
edit: I have mistakenly pressed the button of "best response" to SergeiBaklan and I don't know how to change it :(
