Match list and output message

Help
, , ,
1

Hi,

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?

2

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

3

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

4

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

Regards

Nived N
Happy Automation

5

@keshana_t

Check as below for your reference
https://forum.uipath.com/t/tutorial-another-way-to-check-the-string-is-present-in-excel-or-not/245464/2

Hope this helps you

Thanks

6

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

1 Like
7

Thank you!

8

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