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.
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))
=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 :(
- To convert the result to text, wrap the formula with TEXT, like this:
=TEXT(INDEX(Sheet2!A:A,
MATCH(“*”&A1&”*”,
Sheet2!A:A,0)),"#")
Twifoo , at least that's my understanding of the question. In this its' part.
