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.