I use 2 maps to match the data I've got and the table below is the result.
Some ID2s match 2 different ID1s and therefore should match 2 different IDs, which works fine. However, the ID2 data (downloads) is assigned only to the first ID while the second one gets a value of 0, and I need both IDs to get the same value.
ID(4) = 4 and ID(5) = 4 instead of ID(4) = 4 and ID(5) = 0
Applymap works fine. You only have three ID2 values that have two entries in your mapping table. That's an error because it's impossible to determine which of the two values should be applied. Applymap uses only the first and ignores all others. You may not agree with that logic, but that's the way it works I'm afraid. You'll have to think up some way to make the ID2 values unique.
I think in this case Map (ApplyMap) is wrong function to use.
Just think of ApplyMap as Vlookup in excel, VLookup a id and return first found value (meaning, if you have duplicate Salesperson and different SalesValue, Vlookup will pick up the first value and ignore the sceond). By default DISTINCT is applied.
I will think of another function that might help or you can thik of another function as well
I will try your solution out right away. I was thinking about JOIN as well but I remember reading some posts that don't advice on using it, I don't really know why. Are there any limitations or drawbacks in using it?