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

how can we do this without code?