Hi All,
There are 100 records in column A,B,C respectively.
e.g)
For row3,
if A3 can be found in A1:A100-A3
then check
if B3 can be found in B1:A100-B3
then check
if C3 can be found in C1:C100-C3
then D3 returns "YES" if all true
Else
D3 returns "No"
Now, im using =IF(ISERROR(MATCH(A3,$A$1:$A$100-A3,0)),"No","Yes") for checking A3 and it works fine,,
but i don't know how to keep on checking B3, C3
Thanks for any help.
Bookmarks