Excel help please - filter and fetch values

[gokul1904 (Glory 01)]

I have made a more elaborate post here considering all the points mentioned -

Find match for rows in excel

Hi team, I have below excel data - [image] I have 2 values - “currency” and “account” First I have to check if [first 2 characters of " currency" ] is present in Remit_ID rows.If it has a unique row match , it should return the corresponding “Supplier_ID” for that Remit_ID. If its present in multiple rows or if no rows match, it should check for the [last 4 digits of " account"] in Remit_ID rows.If there is a unique match it should return the corresponding “Supplier_ID” for that Remit_ID. F…

Regards,
G