Compare 3 excel sheet for strore code and write final sheet yes /No

[Anand_Designer (Anand_RPA)]

i have 3 excel sheets 1.pdfo output 2.Region list 3.final report

first check the store code in D column in Pdf output.xlsx then go the Region List.xlsx check the B Column if both matched then check this region name and store name match in final report A, B column if it matched write YES in C cloumn

S714== S714==YES --Remain Are all NO

FInal Report.xlsx (12.0 KB) pdf output.xlsx (9.1 KB) Regions list.xlsx (27.6 KB)

[Pablito (Pawel Wozniak)]

Hi @Anand_Designer,
Please check this thread. You will find there some examples related to data comparison.