excel - find text using formula

I have the employee name1 column  "AC"   and employee father's name in column "AD".

if the value ("name")  is exists in AC and AD I need to put value 2 in the AE .
if only AC OR  AD  value exists  the value should be 1 in COLUMN AE .

If no value exists in both columns the value in AE should be 0.

How do I achieve this using the excel formula ?
Varshini SAsked:
Who is Participating?
Harry LeeConnect With a Mentor Commented:
Use the following formula in Column AE.


That should work for you.
Rgonzo1971Connect With a Mentor Commented:

pls try


Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.