How Update values from one sheet to another sheet in excel

[sayed.tabrez]

I Want to Search Bot and Process name if it is equals then update values like Completed , Error , Progess, Manual Review.

[sayed.tabrez]

Total and Efficiency Is not needed

[LAKSHMI_NARAYANA_PEMMASAN (LAKSHMI NARAYANA)]

try the attached file but change accordingly files and column details , column index

Vlookup.xaml (13.8 KB)

If you have any issues let me know

Regards

[sayed.tabrez]

I get Wrong Output
I need to Check Both Bot and Process Name
Sample Image I Attach Not the exact model Bot Number and Process Name
Sorry My mistake and I Can’t Share the real sample.
Example Excel 1 - Bot 1 - Ks Condition - 1 , 0, 0 ,0
Bot 2 - lo Condition - 3 , 0, 0 ,0
Bot 1 - lo Condition - 2 , 0, 0 ,0
Example Excel 2 - Bot 2 - lo Condition - 1 , 0, 0 ,0
Bot 1 - lo Condition - 3 , 0, 0 ,0
Bot 1 - Ks Condition - 2 , 0, 0 ,0

[LAKSHMI_NARAYANA_PEMMASAN (LAKSHMI NARAYANA)]

Please share excels with dummy data is also fine

Regards

[sayed.tabrez]

New Microsoft Excel Worksheet.xlsx (11.5 KB)
Sheet 2 value need update in Sheet 1

Thank you a lot

[LAKSHMI_NARAYANA_PEMMASAN (LAKSHMI NARAYANA)]

try the attached work flow

JoinDataTables.xaml (20.6 KB)

Based on this you can modify some filters as well

if the sheet1 is going to be standard and new entries gets added then you can keep one more filter for excel filter so that only required rows will be worked

Regards

[sayed.tabrez]

Thank You