Problem description & analysis

Below is Excel file Book1.xlsx:

Loop through each string in column A, during which if column B has one or more strings that are included in the current string, return the last-found one of the N eligible strings of column B to column C in the same row. Below is the desired result:

Solution & explanation

Load add-in ExcelRaq.xll to Excel, and

Enter the following formula in cell C1: =esproc("=?1.select@z1(pos(?2,~))",$B$1:$B$5,A1) and drag C1 down to C5 to get all results.

Q & A Collection

https://stackoverflow.com/questions/63651616/looping-through-range-in-worksheet-and-updating-another-range