Hopefully the title basically explains it!
In Sheet 1 in Column A I have several different references such as ABC_1000, ABC_1001, ABC_1002 etc.
In Sheet2 in Column A will be text such as NOTIFIER_ABC_1000_XXX, NOTIFIER_ABC_1001_XXX etc
In sheet2, in Column C will contain a YES or NO
I just need a formula in Sheet 1 (Column B) that will look at the shortened code in ColumnA, Sheet 1, and find if its a YES or NO in Sheet2 in the long name
Many thanks
In Sheet 1 in Column A I have several different references such as ABC_1000, ABC_1001, ABC_1002 etc.
In Sheet2 in Column A will be text such as NOTIFIER_ABC_1000_XXX, NOTIFIER_ABC_1001_XXX etc
In sheet2, in Column C will contain a YES or NO
I just need a formula in Sheet 1 (Column B) that will look at the shortened code in ColumnA, Sheet 1, and find if its a YES or NO in Sheet2 in the long name
Many thanks