Spreadsheet: 780534d1652525554-formula-to-get-exact-match-with-conditions-6-formula-to-get-exact-match-ans
Sheet: Final Expected Result (2)

Line | As per | [NAME] of supplier | X | Invoice number | Invoice Date | Integrated Tax  (₹) | X | X | Matched with columns B C E F & G | Approximate Match with columns B C E F & G | Matched with columns B C F & G | Approximate Match with columns B C F & G | Matched with columns B C E & G | Approximate Match with columns B C E & G |  | Matched with columns B C E F & G | Approximate Match with columns B C E F & G | Matched with columns B C F & G | Approximate Match with columns B C F & G | Matched with columns B C E & G | Approximate Match with columns B C E & G
1 | PORTAL | 07XXXTB0431R1XD |  | 0000CR2019000893 | 2019-05-22 00:00:00 | 900 |  |  |  |  |  |  |  |  |  |  |  |  | Matched
108 | TALLY | 07XXXTB0431R1XD |  |  | 2019-05-22 00:00:00 | 901 |  |  |  |  |  |  |  |  |  |  |  |  | Matched
2 | PORTAL | 07XXXTB0431R1XD |  | 0000CR2019001162 | 2019-06-05 00:00:00 | 900 |  |  |  |  |  |  |  |  |  |  |  |  | Matched
3 | PORTAL | 07XXXTB0431R1XD |  | 0000CR2019001163 | 2019-06-05 00:00:00 | 900 |  |  |  |  |  |  |  |  |  | Matched | Matched | Matched | Matched
4 | PORTAL | 07XXXTB0431R1XD |  | 0000CR2019001164 | 2019-06-05 00:00:00 | 900 |  |  |  |  |  |  |  |  |  |  |  |  | Matched | Matched | Matched
109 | TALLY | 07XXXTB0431R1XD |  |  | 2019-06-05 00:00:00 | 899 |  |  |  |  |  |  |  |  |  |  |  |  | Matched
110 | TALLY | 07XXXTB0431R1XD |  | 0000CR2019001163 | 2019-06-05 00:00:00 | 900 |  |  |  |  |  |  |  |  |  | Matched | Matched | Matched | Matched | Matched | Matched
111 | TALLY | 07XXXTB0431R1XD |  |  | 2019-06-05 00:00:00 | 901 |  |  |  |  |  |  |  |  |  |  |  |  | Matched
5 | PORTAL | 07XXXTB0431R1XD |  | 0000CR2019001809 | 2019-07-12 00:00:00 | 900 |  |  |  |  |  |  |  |  |  |  |  | Matched | Matched
112 | TALLY | 07XXXTB0431R1XD |  |  | 2019-07-12 00:00:00 | 900 |  |  |  |  |  |  |  |  |  |  |  | Matched | Matched
6 | PORTAL | 07XXXTB0431R1XD |  | 0000CR2019002131 | 2019-07-26 00:00:00 | 900 |  |  |  |  |  |  |  |  |  |  |  |  | Matched
113 | TALLY | 07XXXTB0431R1XD |  |  | 2019-07-26 00:00:00 | 901 |  |  |  |  |  |  |  |  |  |  |  |  | Matched
7 | PORTAL | 07XXXTB0431R1XD |  | 0000CR2019002276 | 2019-08-03 00:00:00 | 900 |  |  |  |  |  |  |  |  |  |  |  |  | Matched
114 | TALLY | 07XXXTB0431R1XD |  |  | 2019-08-03 00:00:00 | 899.5 |  |  |  |  |  |  |  |  |  |  |  |  | Matched
8 | PORTAL | 07XXXTB0431R1XD |  | 0000CR2019003076 | 2019-09-19 00:00:00 | 900 |  |  |  |  |  |  |  |  |  |  |  | Matched | Matched
115 | TALLY | 07XXXTB0431R1XD |  |  | 2019-09-19 00:00:00 | 900.5 |  |  |  |  |  |  |  |  |  |  |  | Matched | Matched
9 | PORTAL | 07XXXTB0431R1XD |  | 0000CR2019003126 | 2019-09-23 00:00:00 | 900 |  |  |  |  |  |  |  |  |  |  |  | Matched | Matched
116 | TALLY | 07XXXTB0431R1XD |  | 3126 | 2019-09-23 00:00:00 | 900 |  |  |  |  |  |  |  |  |  |  |  | Matched | Matched
10 | PORTAL | 07XXXTB0431R1XD |  | 0000CR2019005946 | 2020-02-28 00:00:00 | 900 |  |  |  |  |  |  |  |  |  |  |  | Matched | Matched
117 | TALLY | 07XXXTB0431R1XD |  |  | 2020-02-28 00:00:00 | 900 |  |  |  |  |  |  |  |  |  |  |  | Matched | Matched
11 | PORTAL | 19XXECS5031Q1XV |  | GST-065/19-20 | 2020-02-06 00:00:00 | 1881 |  |  |  |  |  |  |  |  |  |  |  |  | Matched
118 | TALLY | 19XXECS5031Q1XV |  | 65 | 2020-02-06 00:00:00 | 1881.5 |  |  |  |  |  |  |  |  |  |  |  |  | Matched
12 | PORTAL | 19XXECS5031Q1XV |  | GST-052/19-20 | 2019-12-25 00:00:00 | 2520
13 | PORTAL | 19XXECS5031Q1XV |  | GST-053/19-20 | 2020-01-04 00:00:00 | 2520 |  |  |  |  |  |  |  |  |  |  |  | Matched | Matched
119 | TALLY | 19XXECS5031Q1XV |  | 53 | 2020-01-04 00:00:00 | 2520 |  |  |  |  |  |  |  |  |  |  |  | Matched | Matched
14 | PORTAL | 19XXECS5031Q1XV |  | GST-057/19-20 | 2020-01-13 00:00:00 | 2520 |  |  |  |  |  |  |  |  |  |  |  | Matched | Matched
120 | TALLY | 19XXECS5031Q1XV |  | 57 | 2020-01-13 00:00:00 | 2519.5 |  |  |  |  |  |  |  |  |  |  |  | Matched | Matched
121 | TALLY | 27XXOFD3597R1XC |  | 446 | 2020-01-01 00:00:00 | 7520.9
122 | TALLY | 27XXOFD3597R1XC |  | 447 | 2020-01-01 00:00:00 | 7521
123 | TALLY | 27XXOFD3597R1XC |  | 448 | 2020-01-01 00:00:00 | 7522 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Matched
124 | TALLY | 27XXOFD3597R1XC |  | 444 | 2020-01-01 00:00:00 | 7521.45 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Matched
125 | TALLY | 27XXOFD3597R1XC |  | 445 | 2020-01-01 00:00:00 | 7521.45
126 | TALLY | 27XXOFD3597R1XC |  | 443 | 2020-01-01 00:00:00 | 7521.5
15 | PORTAL | 27XXOFD3597R1XC |  | DEI-00438/19-20 | 2019-12-29 00:00:00 | 7521.58
16 | PORTAL | 27XXOFD3597R1XC |  | DEI-00443/19-20 | 2019-12-30 00:00:00 | 7521.58
17 | PORTAL | 27XXOFD3597R1XC |  | 444 | 2019-12-30 00:00:00 | 7521.58 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Matched
18 | PORTAL | 27XXOFD3597R1XC |  | DEI-00445/19-20 | 2019-12-30 00:00:00 | 7521.58
19 | PORTAL | 27XXOFD3597R1XC |  | DEI-00446/19-20 | 2019-12-31 00:00:00 | 7521.58
20 | PORTAL | 27XXOFD3597R1XC |  | DEI-00447/19-20 | 2019-12-31 00:00:00 | 7521.58
21 | PORTAL | 27XXOFD3597R1XC |  | 448 | 2019-12-31 00:00:00 | 7521.58 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Matched