Search for value in another Excel and place the total value in 2 different column corresponding to that value

Hi @HELZMOTH_BJ ,

Please find the below xmal file
Testing_Forum (2).zip (742.8 KB)

try this xmal file and let me know if you are facing any issues