Need to locate all the instances of a list of values in one column in another column that contains text strings

[norwoodkd2001]

I am trying to locate all the instances of a list of values in one column in another column that contains text strings.

Below is an example of my data (in worksheet Column A is 240 rows and Column B is 1115 rows

Column A Column B
iif([#1177] >0,"Y", "N") 762
iif([@762]>#01/01/2013#,DateAdd("d",-15,[@762]),"") 356
iif([1039]="203K",iif([384]="Refinancing",([#1109]/min([#1092]+[#967],[#356])*100),([#1109]/min([#136]+[#967],[#max23k.x6])*100)),0) 1177
(([#2213] + [#2212])/([#2211]/100)) + 100 967

I need to find every row in Column A that contains the value in Column B

I have tried these formula's: =IF(SUMPRODUCT(--(A$1:A$240<>""),--ISNUMBER(FIND(A$1:A$240,B3))),"Yes","No")
=INDEX($B$1:$B$1115, SMALL(IF($B$48=$B$1:$B$1115, ROW($B$1:$B$1115)-MIN(ROW($B$1:$B$1115))+1, ""), ROW(A1)))
But neither of them work. I believe it has something to do with column A being a text string that contains the values I want to find.

Any suggestions? I"m using Excel 2013.

 

[sijpie]

If one column is numbers as text and the other numbers, then you can create a helper column with =TEXT(Bx) and do the comparison on that on (or vice versa =VALUE(Ax) )