get value from one cell and match with other cell

Dear Concerns,

I to get YES value in front of every employee name in sheet name"output". raw data of ICE detail is available in sheet"Input".

we can match Agent value from Input sheet to available CTIOS value in sheet"Team details".

I tried to use following formula but unable to get the value.

IF(LEN(getnumber(Input!C2))<=3,VALUE(getnumber(RIGHT(Input!C2,LEN(Input!C2)-FIND(getnumber(Input!C2),Input!C2,getnumber(Input!C2))))),VALUE(getnumber(Input!C2)))

is this ur fix data ? as in I saw there are spaces in sheet "team details" agent name column and also will you be able to do some find replace (ctrl +H ) action.

if u can then you can standardize all of the agent names in all sheet and then u can either vlookup or match-index ........

Many thanks
R

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.

Hi

I did small changes as I inserted new column in tab input before agent name column...

if any thing is unclear pls let me know...

many thanks
Rishi...