Shell Programming and Scripting

awk '
BEGIN { # Set up translation table for fields to match:
        # fc[file1_field] = file2_field]
        fc[1] = 1
        fc[2] = 4
        fc[3] = 5
        fc[4] = 6
        fc[5] = 7
        fc[6] = 8
        fc[7] = 9
        fc[8] = 18
        fcc = 8 # # of entries in fc[]
}
FNR == NR {
        c = NR  # # of lines in 1st file.
        for(i = 1; i <= 9; i++)
                a[c, i] = $i
        next
}
{       p = 0   # # of lines matched.
        for(i = 1; i <= c; i++) {
                m = 5   # # of fields that must match.
                for(j = 1; j <= fcc && m; j++)
                        if(a[i, j] == $fc[j]) m--
                if(m) continue
                # We matched enough fields; print this as a matched line.
                print $0, a[i, 9]
                p++
        }
        # If we did not find any matching lines, print the not found message.
        if(p == 0) print $0, "Not in file"
}' OFS="\t" file1.txt file2.txt