Comparing two Columns of different Excel sheets in an Excel and replace the column value

Hi guys,

I need to compare two columns of different excel sheets(Sheet1 and Sheet2) and replace the value of Sheet2 to Sheet1.
Please refer attached Excel.

LatamNNILinksRPA.xlsx (2.7 MB)

1 Like

May i know which to column to compare
Cheers @thima

Hi palaniyappan

i need to compare Sheet1 -“ThirdParty” column with Sheet2-“VendorName”

1 Like

Fantastic
here you go
hope its resolved
thima.zip (110.8 KB)

Cheers @thima

1 Like

Thank you for the solution palaniyappan.
its working fine

1 Like

Cheers @thima

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