Job Recruitment Website - Job information - Excel table problem, can not be described, as shown in the figure, a company recruitment list, enter the name and attributes, automatic comparison, the results automatically displayed in column E?

Excel table problem, can not be described, as shown in the figure, a company recruitment list, enter the name and attributes, automatic comparison, the results automatically displayed in column E?

Excel forms enter names and attributes in column A, automatically compare columns B and C, display the results in column E, and then enter formulas in cell E2 and fill them down, as shown below:

=IF(COUNTIF(B2:C2, right (A2)), "Yes", "")

Formulas and renderings