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

[HELZMOTH_BJ]

Actually i forget to tell you that if
Requestor name : John Bell ,then in employee name : value can be John or Bell or John Bell. value can be either full name or firstname or lastname