Spreadsheet: 780540d1652533952-formula-to-get-exact-match-with-conditions-new-formula-to-get-exact-rows-of-match-portal-tally
Sheet: Matched

Line | As per | [NAME] of supplier | X | Invoice number | Invoice Date | Integrated Tax  (₹) | X | X | Approximate Match with columns B C F & G | Expected Result
27 | TALLY | 07XXXTB0431R1XD |  |  | 2019-06-05 00:00:00 | 899 |  |  |  | MATCHED
33 | TALLY | 07XXXTB0431R1XD |  |  | 2019-08-03 00:00:00 | 899.5 |  |  |  | MATCHED
34 | TALLY | 07XXXTB0431R1XD |  |  | 2019-08-03 00:00:00 | 899.5
37 | TALLY | 07XXXTB0431R1XD |  |  | 2019-09-23 00:00:00 | 899.5 |  |  |  | MATCHED
1 | PORTAL | 07XXXTB0431R1XD |  | 0000CR2019000893 | 2019-05-22 00:00:00 | 900 |  |  |  | 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
28 | TALLY | 07XXXTB0431R1XD |  | 0000CR2019001163 | 2019-06-05 00:00:00 | 900 |  |  |  | MATCHED
4 | PORTAL | 07XXXTB0431R1XD |  | 0000CR2019001164 | 2019-06-05 00:00:00 | 900 |  |  |  | MATCHED
5 | PORTAL | 07XXXTB0431R1XD |  | 0000CR2019001169 | 2019-06-05 00:00:00 | 900
6 | PORTAL | 07XXXTB0431R1XD |  | 0000CR2019001809 | 2019-07-12 00:00:00 | 900 |  |  |  | MATCHED
30 | TALLY | 07XXXTB0431R1XD |  |  | 2019-07-12 00:00:00 | 900 |  |  |  | MATCHED
7 | PORTAL | 07XXXTB0431R1XD |  | 0000CR2019002131 | 2019-07-26 00:00:00 | 900 |  |  |  | MATCHED
8 | PORTAL | 07XXXTB0431R1XD |  | 0000CR2019002276 | 2019-08-03 00:00:00 | 900 |  |  |  | MATCHED
9 | PORTAL | 07XXXTB0431R1XD |  | 0000CR2019003076 | 2019-09-19 00:00:00 | 900 |  |  |  | MATCHED
11 | PORTAL | 07XXXTB0431R1XD |  | 0000CR20190031200 | 2019-09-23 00:00:00 | 900
12 | PORTAL | 07XXXTB0431R1XD |  | 0000CR20190031201 | 2019-09-23 00:00:00 | 900
10 | PORTAL | 07XXXTB0431R1XD |  | 0000CR2019003126 | 2019-09-23 00:00:00 | 900 |  |  |  | MATCHED
13 | PORTAL | 07XXXTB0431R1XD |  | 0000CR20190031202 | 2019-09-24 00:00:00 | 900
14 | PORTAL | 07XXXTB0431R1XD |  | 0000CR2019005946 | 2020-02-28 00:00:00 | 900 |  |  |  | MATCHED
38 | TALLY | 07XXXTB0431R1XD |  |  | 2020-02-28 00:00:00 | 900 |  |  |  | MATCHED
35 | TALLY | 07XXXTB0431R1XD |  |  | 2019-08-03 00:00:00 | 900.5
36 | TALLY | 07XXXTB0431R1XD |  |  | 2019-09-19 00:00:00 | 900.5 |  |  |  | MATCHED
26 | TALLY | 07XXXTB0431R1XD |  |  | 2019-05-22 00:00:00 | 901 |  |  |  | MATCHED
29 | TALLY | 07XXXTB0431R1XD |  |  | 2019-06-05 00:00:00 | 901 |  |  |  | MATCHED
31 | TALLY | 07XXXTB0431R1XD |  |  | 2019-07-26 00:00:00 | 901 |  |  |  | MATCHED
32 | TALLY | 07XXXTB0431R1XD |  |  | 2019-07-26 00:00:00 | 901
15 | PORTAL | 19XXECS5031Q1XV |  | GST-065/19-20 | 2020-02-06 00:00:00 | 1881 |  |  |  | MATCHED
39 | TALLY | 19XXECS5031Q1XV |  | 65 | 2020-02-06 00:00:00 | 1881.5 |  |  |  | MATCHED
41 | TALLY | 19XXECS5031Q1XV |  | 57 | 2020-01-13 00:00:00 | 2519.5 |  |  |  | MATCHED
16 | PORTAL | 19XXECS5031Q1XV |  | GST-052/19-20 | 2019-12-25 00:00:00 | 2520
40 | TALLY | 19XXECS5031Q1XV |  | 53 | 2020-01-04 00:00:00 | 2520 |  |  |  | MATCHED
17 | PORTAL | 19XXECS5031Q1XV |  | GST-053/19-20 | 2020-01-04 00:00:00 | 2520 |  |  |  | MATCHED
18 | PORTAL | 19XXECS5031Q1XV |  | GST-057/19-20 | 2020-01-13 00:00:00 | 2520 |  |  |  | MATCHED
42 | TALLY | 27XXOFD3597R1XC |  | 446 | 2020-01-01 00:00:00 | 7520.9
43 | TALLY | 27XXOFD3597R1XC |  | 447 | 2020-01-01 00:00:00 | 7521
45 | TALLY | 27XXOFD3597R1XC |  | 444 | 2020-01-01 00:00:00 | 7521.45
46 | TALLY | 27XXOFD3597R1XC |  | 445 | 2020-01-01 00:00:00 | 7521.45
47 | TALLY | 27XXOFD3597R1XC |  | 443 | 2020-01-01 00:00:00 | 7521.5
19 | PORTAL | 27XXOFD3597R1XC |  | DEI-00438/19-20 | 2019-12-29 00:00:00 | 7521.58
21 | PORTAL | 27XXOFD3597R1XC |  | 444 | 2019-12-30 00:00:00 | 7521.58
20 | PORTAL | 27XXOFD3597R1XC |  | DEI-00443/19-20 | 2019-12-30 00:00:00 | 7521.58
22 | PORTAL | 27XXOFD3597R1XC |  | DEI-00445/19-20 | 2019-12-30 00:00:00 | 7521.58
25 | PORTAL | 27XXOFD3597R1XC |  | 448 | 2019-12-31 00:00:00 | 7521.58
23 | PORTAL | 27XXOFD3597R1XC |  | DEI-00446/19-20 | 2019-12-31 00:00:00 | 7521.58
24 | PORTAL | 27XXOFD3597R1XC |  | DEI-00447/19-20 | 2019-12-31 00:00:00 | 7521.58
44 | TALLY | 27XXOFD3597R1XC |  | 448 | 2020-01-01 00:00:00 | 7522