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.
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))
Twifoo , at least that's my understanding of the question. In this its' part.