Excel help please - filter and fetch values

@gokul1904
we would recommend to handle more complete the requirements and its description
a more clear and complete requirement description results to a more fast solution suggestion

Currently:

  • the datasamples and the mentioned scenarios do not match
    • e.g. we have currency as “BRA” and account number as “987893456” then Supplier_ID - SUPPLIER_CONNECTION-3-2345

we dont see: 987893456 so what is the rule of returning: SUPPLIER_CONNECTION-3-2345

Same for

Thanks for support