using finditem when there are two of the same names in a list each with a different code
I have a line item in this module called "TPS System Takeout" and in the column next to it "TPS Competitor Report Type Classification" i want it to find the matching name in this list "CTO Competitor Classification Types"
You can see that RaySearch was populated because the code for RaySearch in the list is "RaySearch". Nothing else populates because I created a unique code for each classification type. My problem is that there is a MIM under TPA Category and a MIM under Velocity Category as example. They cant have the same code but it seems that the only way to find the matching type and list it in the module is if the codes are equal to what is in "TPS System Takeout" column. Is there another way to do this?
Thanks a bunch!