UNIX for Advanced & Expert Users

 awk 'NR=FNR{a[NR]=$0;next} { split ( a[$1],x, " ") if ( ( $2 ~ x[1] ) and ( $5 ~ x[2] ) ) { print $0 > "yes.txt"; } else { print $0 > " no.txt" } ; } file2 file1 2>> log.txt

1234 chennai kovai 1256 blr
2331 Madras Coimbatore 3234 Bangalore
5467 Chennai city 2456 ooty

Madras Bangalore
Chennai blr

1234 chennai kovai 1256 blr

2331 Madras Coimbatore  3234 Bangalore 
5467 Chennai city 2456 ooty

awk     'NR==FNR                {a[$1,$2]; next}
         ($2 SUBSEP $5 in a)    {print $0 > "yes.txt"; next}
                                {print $0 > "no.txt" }
        ' file2 file1
cf *.txt
no.txt:
5467 Chennai city 2456 ooty
yes.txt:
1234 Chennai kovai 1256 blr
2331 Madras Coimbatore 3234 Bangalore

akshay@nio:/tmp$ cat f1
1234 chennai kovai 1256 blr
2331 Madras Coimbatore 3234 Bangalore
5467 Chennai city 2456 ooty

akshay@nio:/tmp$ cat f2
Madras Bangalore
Chennai blr

akshay@nio:/tmp$ awk 'FNR==NR{A[tolower($1 FS $2)];next}{print >sprintf("%s.txt",(tolower($2 FS $5) in A ? "yes" : "no"))}' f2 f1

akshay@nio:/tmp$ cat yes.txt 
1234 chennai kovai 1256 blr
2331 Madras Coimbatore 3234 Bangalore

akshay@nio:/tmp$ cat no.txt 
5467 Chennai city 2456 ooty

awk '
NR == FNR {
        a[tolower($1)] = tolower($2)
        next
}
tolower($2) in a && a[tolower($2)] == tolower($5) {
        print > "yes.txt"
        next
}
{       print > "no.txt"
}' file2 file1 2>> log.txt

    if ( ( $2 ~ x[1] ) and ( $5 ~ x[2] ) )  or (( $2 ~ x[2] ) and ( $5 ~ x[1] )) { print $0 > "yes.txt"; } else { print $0 > " no.txt" } ; } file2 file1 2>> log.txt

York  oo

123 Yorkshire x y boot

456 York a b oo