Hi Excelers,

Total Remuneration TEMPLATE.xlsx

On the Template tab I am trying to bring through the amount in column I of the ALW Data Dump tab but only if the staff member in template and the staff member in ALW Data Dump match along with the code in the ALW Data Dump tab in column H being "CALL", otherwise I want it to just bring through 0.

I only want this column to bring through amounts coded to CALL for the specific employees, the list is likely to change so cannot be hard coded.

Any help would be amazing.

Thanks :