Find multiple cells of data in column

Solution 1:

If you have the TEXTJOIN function, try:

Edit
As pointed out by @AdamV, my first solution would only work on single character entries in the diff column. I have modified it to work on your data as shown

Original incorrect solution =FIND(TEXTJOIN(,,what_to_find),TEXTJOIN(,,diff%))

Corrected formula:
we pad each entry so that all have the same number of characters before doing the find

=INT(FIND(TEXTJOIN(,,RIGHT(REPT("0",16)&what_to_find,16)),TEXTJOIN(,,RIGHT(REPT("0",16)&diff,16)))/16)+1

It will return the position in the left hand column where the right hand column pattern starts.