Formula to check if specific name is present in 3 different lists.

list1 list2 list3 check Yes/No
abc ;lk nm abc
xzy poi zxc xzy
asd .,m nme poi
qwe nm
n


I have the above data in an excel file, in the last column I would like to get yes if the value in "check" column is present in either of the 3 lists and no if it is not present.

Here is a solution. In G2, type the following formula and drag it down the column.

=IF(ISNUMBER(MATCH(F2,A2:C2,0)),"Yes","No")

Originally Posted by majosum

Here is a solution. In G2, type the following formula and drag it down the column.

=IF(ISNUMBER(MATCH(F2,A2:C2,0)),"Yes","No")

hi thanks for reply but that is only checking 1st list.

Hello,

can someone plz help me with this.

thanks

In cell G2 enter =COUNTIF(A2:C5,F2) and drag down. this will return a 1 if the entry is present anywhere in any of the three lists (Or however many instances there are in the entire area). If you really need it to say yes or no and there will be multiple instances you can add a column and enter =IF(G2>0,"Yes","No") and then hide the G column. For a simple solution I hope