Find match for rows in excel

Let us have a look at the rule definition

strCUR = EUR, strACC = 123456

EUR → has one Match so from your rule set it returns the 3627 Remit
3456 → has a match to the 2345 Remit

Currently the approach is assigning a rating mask base on cur / acc check

ACCCheck CurrCheck Mask Int
Y N 10 10
Y Y 11 11
N N 00 0
N Y 01 1

Where filtered out the cases of 0

We would suggest to advance with it, when you want take this approach and

  • swap the most important criteria
  • return all Remits with its rating mask and postprocess it
1 Like