Match column and update after concatinating to another column

[Gokul_Jayakumar (Gokul Jai)]

@Shilpa_Mohanty

f “Made #” is matched
Concatenate Made #, Made Field 2, Made Field 4 in Sheet 1
Format: Made# - Made Field 2 Made Field 4
Replace “Made #” value in Sheet2 worksheet.
Lookup the Made# from Sales worksheet to return “Made# - Made Field 2 Made Field 4” value.
(If made # in both sheets match, then we need to concatenate Made #, Made Field 2, Made Field 4 from Sheet1 and update in Sheet2 for Made #)
Sample.xlsx (10.3 KB)

@Shilpa_Mohanty
Kindly refer to this, Already posted in your previous post, have a look at it

Match column and update after concating to another column

@Shilpa_Mohanty Kindly refer to the Xaml file Forum_ExcelConCatenate.zip (89.8 KB) Output [image] Above shown output was expected?