So I would like to Populate Columns on the Distribution Log Tab (From the Asset Data Tab)
C (from C), D (From D), E (From F) L (from I) and P (From H)
However, In the asset data tab where we need to identify the correct entries to pull the date from using both the ISIN (A) and the Register holder (G) as there are multiple holders for the same isin.
So on the distribution tab ISIN (N) and Unitholder (G) need to match the ISIN (A) and Registered holder (G) on the asset data tab and pull through the corresponding information.
I have tried an Index and match but it never works for me. Any help would be really appreciated!!