How to update one sheet column value to another sheet column based on matching value particular

[Raja.G (Mr.RPABot)]

Hi Team,

I need to update one sheet particular column value to update another sheet based on matching of one particular column value

I have sheet 1 and sheet 2 in excel, column name both same only i want to get sheet 2 status to update in sheet 1 to matching the name column

if XXX column value in sheet 2 status is Inactive but sheet 1 XXX value Active means should change sheet 1 status inActive

Input excel:
sheet 1:

Sheet 2:

Result:

Please anyone help me for this.

Regards,
Raja G

[arjunshenoy]

Hi @Raja.G

You can achieve the desired output by implementing the ‘VLookUp’ operation. Please refer the following content.

How to do Excel VLOOKUPs in UiPath RPA (Full Tutorial)

Hope this helps,
Best Regards.

[Jithesh_R]

Hii, @Raja.G
Please find the below attached workflow.
Sheet2ToSheet1.xaml (11.2 KB)

Hope this might help you.

[amalmarella (Amal M)]

hi

if the data set is small , you can use below simple approach

for each row1 in dt1

for each row2 in dt2

if row1(“Name”)=row2(“Name”)
{
row1(“Status”)=row2(“Status”)
}

[Raja.G (Mr.RPABot)]

Hi @Jithesh_R ,

Your file not open

Please share xmal file

[Jithesh_R]

Please check it now If it doesn’t open please refer the Screenshot.
Sheet2ToSheet1.zip (2.0 KB)

[Raja.G (Mr.RPABot)]

Hi @Jithesh_R ,

Working fine Thanks ,but possible to paste result with same format (color is there in some cells) to sheet1 and any way to bulid lookup via.

Regards,
Raja G

[Jithesh_R]

Hi @Raja.G ,
Sorry didnt get you ,it will be better if you share the file having Colours ,then we can see what we can do.

Regards,

[Raja.G (Mr.RPABot)]

Hi @Jithesh_R ,

Working fine thanks