I am trying to match the (Sum of amount) on the Main tab in Column C that corresponds to each policy in column A on the secondary tab that matches the account columns on the secondary tab (2412100, 2416300, and 2203400)
Only way Ive been able to do it is by pulling the accounts out into separate tabs and just doing a Vlookup say its on a tab 2100 and the policy is in A and the money is in B then Vlookup(trim(a2),2412100!A:C,3,0) - I just used one example - but thats the only way I can do it.
But there has to be an easier way?