Need un macthed result
Role
E.AM_SEN.FIXED_ASST_COOR:B17
E.FA_SEN.DIV_FA_CO-ORD_ACN:B17
E.FI_COR.ENT_FIX_AST_YR_CLS:S
E.FI_SEN.ENT_FIX_ASST_ADMIN:S
E.FI_SEN.ENT_NUS_ASSET_ADM:B17
E.FI_SEN.ENT_NUS_ASSET_ADM:S
E.FI_SEN.FIXED_ASSET_ADMIN:S
E.FI_SEN.NUS_FIX_ASSET_ADM:B17
E.WF_SEN.FIXED_ASSET:B17
FA_410:S?:00
WF_005:S?:00
Z:APP_DIV_NOHR
E.AM_SEN.FIXED_ASST_COOR:B17
E.BC_COR.CATT_ALL:S
E.FA_SEN.DIV_FA_CO-ORD_ACN:B17
E.FI_COR.ENT_FIX_AST_YR_CLS:S
E.FI_SEN.ENT_FIX_ASST_ADMIN:S
E.FI_SEN.ENT_NUS_ASSET_ADM:B17
E.FI_SEN.ENT_NUS_ASSET_ADM:S
Role
E.AM_SEN.FIXED_ASST_COOR:B17
E.FA_SEN.DIV_FA_CO-ORD_ACN:B17
E.FI_COR.ENT_FIX_AST_YR_CLS:S
E.FI_SEN.ENT_FIX_ASST_ADMIN:S
E.FI_SEN.ENT_NUS_ASSET_ADM:B17
E.FI_SEN.ENT_NUS_ASSET_ADM:S
E.FI_SEN.FIXED_ASSET_ADMIN:S
E.FI_SEN.NUS_FIX_ASSET_ADM:B17
E.WF_SEN.FIXED_ASSET:B17
FA_410:S?:00
WF_005:S?:00
Z:APP_DIV_NOHR
E.AM_SEN.FIXED_ASST_COOR:B17
E.BC_COR.CATT_ALL:S
E.FA_SEN.DIV_FA_CO-ORD_ACN:B17
E.FI_COR.ENT_FIX_AST_YR_CLS:S
E.FI_SEN.ENT_FIX_ASST_ADMIN:S
E.FI_SEN.ENT_NUS_ASSET_ADM:B17
E.FI_SEN.ENT_NUS_ASSET_ADM:S
In above roles i need to check wheater any of role are matched with below roles
ExampleL
E.FA_SEN.DIV_FA_CO-ORD_ACN:B17=E.FA_SEN.DIV_FA_CO-ORD_ACN:M
E.FA_SEN.DIV_FA_CO-ORD_ACN=E.FA_SEN.DIV_FA_CO-ORD_ACN matched
If its macthed i need unmatched result
Role
E.AM_SEN.FIXED_ASST_COOR:M
E.FA_SEN.DIV_FA_CO-ORD_ACN:M
E.FI_COR.ENT_FIX_AST_YR_CLS:S
E.FI_SEN.ENT_FIX_ASST_ADMIN:S
E.FI_SEN.ENT_NUS_ASSET_ADM:M
E.FI_SEN.ENT_NUS_ASSET_ADM:S
E.FI_SEN.FIXED_ASSET_ADMIN:S
E.FI_SEN.NUS_FIX_ASSET_ADM:M
E.WF_SEN.FIXED_ASSET:M
FA_410:S?:00
WF_005:S?:00
Z:APP_DIV_NOHR
E.AM_SEN.FIXED_ASST_COOR:M
E.BC_COR.CATT_ALL:S
E.FA_SEN.DIV_FA_CO-ORD_ACN:M
E.FI_COR.ENT_FIX_AST_YR_CLS:S
E.FI_SEN.ENT_FIX_ASST_ADMIN:S
E.FI_SEN.ENT_NUS_ASSET_ADM:M
E.FI_SEN.ENT_NUS_ASSET_ADM:S
E.FI_SEN.FIXED_ASSET_ADMIN:S
E.FI_SEN.NUS_FIX_ASSET_ADM:M
FA_410:S?:00
Z:APP_DIV_NOHR
CM_060:S_:00
CM_190:S_:00
E.AM_SEN.FIXED_ASST_COOR:M
E.BC_COR.CATT_ALL:S
E.BC_SEN.CPIC_4_MAXIMO:S
E.CM_COR.APP_DEV_PROJ_RATE:M
E.CM_COR.MANAGE_DEVL_PROJ:M
create another column
create another column removing everything to the right of ":"
use the VLOOKUP formula