excel - Find and match only first 5 character in 2 columns

Question

Maybe u can help me with the formula.

Column 1 (named A) containt 2590 rows with 5 numbers like

12345
41266
71263
12653
71263

Column2 (named H) contains only 300 rows with numbers like:

71637126371623
67126317236173
61616161162542
71621762165265

I need to match column1 and column2 and find rows in column2 which contains 5 digits numbers from column1

Answer 1

Assuming you only want to look whether the cells next to each other 1 is a substring of the other, you can get the result with if,isnumber,search, all in one:

=IF(ISNUMBER(SEARCH(A2,B2)),1,0)