Thanks for your response.
yes you are right that there are some spaces in name column. however i think we need to find ctios id from team details column B to input sheet column A as there are some speeling changes in input sheet.
kindly apply forumla ans attached that sheet.