Crosscheck code lives in source sheet
I need help, would like to see if possible to set up formula to crosscheck the code lives in different source sheet and get result YES/NO in Target sheet. I do have 9 source sheet & 1 target sheet.
All the sheets (total 10) that is having unique common code it can be the key value.
I tried to combine 9 sheets to a report and set up formula in target sheet, however, the report is unable to set as a reference sheet, so it's failed.
Is that possible combine different source sheet & work out one pivot table then set formula ?
a.) Don't know how to make one pivot with different worksheet.
b.) Pivot can be set as a reference sheet ?
Appreciate pls share any recommendation on how to get the result YES/NO in target sheet even we can do more step.
Help Article Resources
Check out the Formula Handbook template!