Hello,

Bumping a thread that is over a month old.

Here is an updated workbook with the expected result :

number verification.xlsx

From the other thread, I found a solution for column B and D :

B formula for sheet2:

=IF(COUNTIF(List!A:A,A2),"Yes","No")

B formula for sheet3:

=IF(SUM(COUNTIF(List!A:A,TEXTSPLIT(Sheet3!A2,"-")))>0,"Yes","No")

D for sheet2 and sheet3:

=IF(SUM(--ISNUMBER(SEARCH(C2&", ",SUBSTITUTE(List!$C:$C,"-",", ")&", ")))>0,"Yes","No")

I have yet to find a solution for column E. Formula only, no VBA. Is this possible without VBA ?