Hey mate, I think you have runned into a similar issue I had short time ago, you want to compare two lists and find out the matching ones and assing a value according to it.
here is the post were my issue was solved, hope it can help:
(I will try to test it with your data, no promises I will achieve something, hopefully some veteran will do it shortly)