Lookup step returning unexpected values
I am currently using version 188.8.131.52.
I've discovered recently that in one of my workflows, the Lookup step is not returning the expected results in all cases. I have quickly set up a test scenario I have attached below.
The idea is the following: The lookup should give back the "Value" column's values in cases where Code1=Code1 and Indic1=Indic2.
In the attached case, in my understanding the expected value would be "DEFAULT" for row 7, but I get N/A instead.
There is also another lookup column which is set up to show if a record where Code1=Code1 and Indic1=Indic2 exists at all, but that returns True, even if there is no "ID13" for Indic2
Can you please take a look and see if this is intended, and if so, advise on how I might be able to achieve the desired result?
Thanks in advance.