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
Please anyone help me for this.
You can achieve the desired output by implementing the ‘VLookUp’ operation. Please refer the following content.
Hope this helps,
Please find the below attached workflow.
Sheet2ToSheet1.xaml (11.2 KB)
Hope this might help you.
if the data set is small , you can use below simple approach
for each row1 in dt1
for each row2 in dt2
Please check it now If it doesn’t open please refer the Screenshot.
Sheet2ToSheet1.zip (2.0 KB)
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.
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.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.