Compare 2 excel file data - Like option use in compare the row value

Dear Team,

Excel1 - NEFT_Name
Excel2 - Cust_Name

1.Search excel2 with Like option in column NEFT_Name. if matched, should return. ex., compare the value “Sun Market” and return as “Sun Marketing Ltd”.
Stream Lookup- will return with only match value, my case need to use like option.

2.Failed row values alone (ie., not matching values) should be display in red color.

image
image

badges