get value from one cell and match with other cell

[fscheikh]

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)))