Match list and output message


I have a list of names in Sheet 1 and Sheet 2 of an Excel spreadsheet. How can I check the list of names in Sheet 2 against the list of names in Sheet 1 and to output a Match/No Match for each name in Sheet 2?

Hi @keshana_t do u need to check whether the name in sheet2 is present in sheet1?

Hi yes, that’s right. And I’d like a written output with Match/No Match for each name.

Hi @keshana_t check this workflow

Main.xaml (10.0 KB)

Hope it helps you

Mark it as solution if you got answer to ur query


Nived N
Happy Automation


Check as below for your reference

Hope this helps you


Apologies for the late reply but this works, thank you!

1 Like

Thank you!

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.