I have 2 workbooks with various matching data and i would like this to be indicated with "yes" or a "no" in a seperate column in the 2nd workbook, is this possible?

In workbook 1 i have the date in column A and a name in column C, in workbook 2 i have the date in column C and a name in column L, can anyone help me with a formula to check if any of the data in column A and Column C of workbook 1 is the same as column C and Column L in workbook 2?

Any help is much appreciated