Spreadsheet: 780534d1652525554-formula-to-get-exact-match-with-conditions-6-formula-to-get-exact-match-ans
Sheet: Result of B C E F G

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
1 | PORTAL | 07XXXTB0431R1XD |  | 0000CR2019000893 | 2019-05-22 00:00:00 | 900
108 | TALLY | 07XXXTB0431R1XD |  |  | 2019-05-22 00:00:00 | 901
2 | PORTAL | 07XXXTB0431R1XD |  | 0000CR2019001162 | 2019-06-05 00:00:00 | 900
3 | PORTAL | 07XXXTB0431R1XD |  | 0000CR2019001163 | 2019-06-05 00:00:00 | 900 |  |  | Matched | Matched
4 | PORTAL | 07XXXTB0431R1XD |  | 0000CR2019001164 | 2019-06-05 00:00:00 | 900
109 | TALLY | 07XXXTB0431R1XD |  |  | 2019-06-05 00:00:00 | 899
110 | TALLY | 07XXXTB0431R1XD |  | 0000CR2019001163 | 2019-06-05 00:00:00 | 900 |  |  | Matched | Matched
111 | TALLY | 07XXXTB0431R1XD |  |  | 2019-06-05 00:00:00 | 901
5 | PORTAL | 07XXXTB0431R1XD |  | 0000CR2019001809 | 2019-07-12 00:00:00 | 900
112 | TALLY | 07XXXTB0431R1XD |  |  | 2019-07-12 00:00:00 | 900
6 | PORTAL | 07XXXTB0431R1XD |  | 0000CR2019002131 | 2019-07-26 00:00:00 | 900
113 | TALLY | 07XXXTB0431R1XD |  |  | 2019-07-26 00:00:00 | 901
7 | PORTAL | 07XXXTB0431R1XD |  | 0000CR2019002276 | 2019-08-03 00:00:00 | 900
114 | TALLY | 07XXXTB0431R1XD |  |  | 2019-08-03 00:00:00 | 899.5
8 | PORTAL | 07XXXTB0431R1XD |  | 0000CR2019003076 | 2019-09-19 00:00:00 | 900
115 | TALLY | 07XXXTB0431R1XD |  |  | 2019-09-19 00:00:00 | 900.5
9 | PORTAL | 07XXXTB0431R1XD |  | 0000CR2019003126 | 2019-09-23 00:00:00 | 900
116 | TALLY | 07XXXTB0431R1XD |  | 3126 | 2019-09-23 00:00:00 | 900
10 | PORTAL | 07XXXTB0431R1XD |  | 0000CR2019005946 | 2020-02-28 00:00:00 | 900
117 | TALLY | 07XXXTB0431R1XD |  |  | 2020-02-28 00:00:00 | 900
11 | PORTAL | 19XXECS5031Q1XV |  | GST-065/19-20 | 2020-02-06 00:00:00 | 1881
118 | TALLY | 19XXECS5031Q1XV |  | 65 | 2020-02-06 00:00:00 | 1881.5
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
119 | TALLY | 19XXECS5031Q1XV |  | 53 | 2020-01-04 00:00:00 | 2520
14 | PORTAL | 19XXECS5031Q1XV |  | GST-057/19-20 | 2020-01-13 00:00:00 | 2520
120 | TALLY | 19XXECS5031Q1XV |  | 57 | 2020-01-13 00:00:00 | 2519.5
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
124 | TALLY | 27XXOFD3597R1XC |  | 444 | 2020-01-01 00:00:00 | 7521.45
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
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