Hi all, I am currently working on a workflow to compare two sheets.
SheetA: contains keywords
SheetB: contains chunk of words
my goal is to look for keywords contained in sheetA in sheetB just like how ctrl f works in excel. if the keyword existed in sheetA, i will extract information from both sheets and store them in a new sheet.
i used two for each row activities and have tried the formula indexof in this form:
the former represents the row in sheetB and the latter represents the keyword in sheetA.
however, the method did not extract out the information correctly and completely.
I really need help on this as assignment dateline is approaching and i have searched up and down for solution on google but none works. i have attached my workflow together with the sample file that i am working on. i would really appreciate for your kind attention and help (32.0 KB)