I want to reference S1 and S3 to S2 and fetch the matched records aswell as the unmatched records from S1 and S3,
Let me know if the " , " separated value in S3 sheet, should be made into additional rows, also the Data source is excel files.
|CR#1||Release date||Product name||Lead||Domain|
|CR0020, CR009, CR21||CR0031||CC||mic|
If null data, show it as blank " "
Would really appreciate your help.
Message was edited by: Richie Berlin i have cleansed the data, let me know if I should be making the " , " separated additional row or this is fine.