Problem with replacing SELECT with LOOKUP
I am replacing SELECT functions with LOOKUP as a part of model optimization (2.02-14 Avoid using SELECT). I did it lots of times and they worked but I am struggling with couple of them.
My approach is that I use mapping module to use LOOKUP instead SELECT. I add list formatted line item and select the list item (which is used by SELECT function) from dropdown. Then I use LOOKUP with this line item.
I added screenshots of the formulas for 2 line items. They should have same results but they are not. Can you help me to understand what is wrong here?