Match contains

[AbrahamGluck]

in column A I have a list of values


in column B i have a different list of values

In column C I would like to search which row in column B contains the value of column A for the current row

for example
Cell A1 is exactly ABCD
cell B5 is 1234 FDSA ABCD
so the return for column C should be row 5

 

[DanteAmor]

Try this

=MATCH("*"&A1&"*",B:B,0)

 

[AbrahamGluck]

Try this

=MATCH("*"&A1&"*",B:B,0)

Thanks!

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.