You could use a helper column (column C) of cells with formulas like:

=INDEX(B:B,MATCH("*"&A1&"*",B:B,0))
and drag down.

If there is no match, you'll see an #n/a error.

If you're just looking for the row that has the match:
=MATCH("*"&A1&"*",B:B,0)





cretesupplies wrote:

i have to columns in an Excel worksheet.
Column A has codes(text),one in every cell.
Column B has description(text)one in every cell.
Codes from column A exist somewhere in column B and some not.

How do i match the cells from column A to the cells in column B that under
the condition that a cell in column B contains the string from column A

Thank u in advance

--

Dave Peterson