Spreadsheet: 861525d1709399834-index-match-avoid-n-a-index-match-avoid-na
Sheet: Sheet1

 |  | INDEX - MATCH - AVOID #N/A |  |  |  |  |  |  |  |  | Comparision Columns
 |  | How to replace "#N/A" with "Invoice Not Paid"
 | Invoices | Paid Date | Chk. # | ® Search  / Match Invoice # and return Paid Date or Check # |  |  |  |  |  |  | Paid Date | Check # | Invoices Paid
 | I735 |  | Invoice Not Paid |  |  |  |  |  |  |  | 2022-09-28 00:00:00 | 4841 | 1568 |  |  | Invoice Not Paid
 | I1075 | Invoice Not Paid | Invoice Not Paid |  |  |  |  |  |  |  | 2022-09-28 00:00:00 | 4982 | 1567 |  | Invoice Not Paid | Invoice Not Paid
 | I1077 | Invoice Not Paid | Invoice Not Paid |  |  |  |  |  |  |  | 2022-09-28 00:00:00 | 5537 | 1583 |  | Invoice Not Paid | Invoice Not Paid
 | I1160 | Invoice Not Paid | Invoice Not Paid |  |  |  |  |  |  |  | 2022-11-07 00:00:00 | 4982 | 1736 |  | Invoice Not Paid | Invoice Not Paid
 | I1442 | Invoice Not Paid | Invoice Not Paid |  |  |  |  |  |  |  | 2022-11-07 00:00:00 | 4982 | 1804 |  | Invoice Not Paid | Invoice Not Paid
 | I1654 | Invoice Not Paid | Invoice Not Paid |  |  |  |  |  |  |  | 2022-12-12 00:00:00 | 5537 | 1737 |  | Invoice Not Paid | Invoice Not Paid
 | I1655 | Invoice Not Paid | Invoice Not Paid |  |  |  |  |  |  |  | 2022-12-12 00:00:00 | 5537 | 1906 |  | Invoice Not Paid | Invoice Not Paid
 | I1738 | Invoice Not Paid | Invoice Not Paid |  |  |  |  |  |  |  | 2022-12-12 00:00:00 | 5537 | 1907 |  | Invoice Not Paid | Invoice Not Paid
 | I1854 | Invoice Not Paid | Invoice Not Paid |  |  |  |  |  |  |  | 2022-12-12 00:00:00 | 5537 | 1908 |  | Invoice Not Paid | Invoice Not Paid
 | [NAME] | 2023-11-28 00:00:00 | 6842 |  |  |  |  |  |  |  | 2022-12-12 00:00:00 | 5537 | 1988 |  | 2023-11-28 00:00:00 | 6842
 | I1885 | Invoice Not Paid | Invoice Not Paid |  |  |  |  |  |  |  | 2022-12-12 00:00:00 | 5537 | 1076 |  | Invoice Not Paid | Invoice Not Paid
 | I1994 | 2023-11-28 00:00:00 | 6842 |  |  |  |  |  |  |  |  |  |  |  | 2023-11-28 00:00:00 | 6842
 | I2040 | 2023-11-28 00:00:00 | 6842 |  |  |  |  |  |  |  | 2023-01-26 00:00:00 | 5669 | I1254 |  | 2023-11-28 00:00:00 | 6842
 | I2078 | Invoice Not Paid | Invoice Not Paid |  |  |  |  |  |  |  | 2023-01-26 00:00:00 | 5669 | I1256 |  | Invoice Not Paid | Invoice Not Paid
 | [NAME] | Invoice Not Paid | Invoice Not Paid |  |  |  |  |  |  |  | 2023-01-26 00:00:00 | 5669 | I1336 |  | Invoice Not Paid | Invoice Not Paid
 | I2096 | 2023-11-28 00:00:00 | 6842 |  |  |  |  |  |  |  | 2023-02-03 00:00:00 | 5687 | I1253 |  | 2023-11-28 00:00:00 | 6842
 | I2107 | 2023-11-28 00:00:00 | 6842 |  |  |  |  |  |  |  | 2023-02-03 00:00:00 | 5687 | I1440 |  | 2023-11-28 00:00:00 | 6842
 | I2145 | 2023-11-28 00:00:00 | 6842 |  |  |  |  |  |  |  | 2023-02-03 00:00:00 | 5687 | I1441 |  | 2023-11-28 00:00:00 | 6842
 | I2252 | 2023-11-28 00:00:00 | 6842 |  |  |  |  |  |  |  | 2023-02-20 00:00:00 | 5729 | I1539 |  | 2023-11-28 00:00:00 | 6842
 | I2261 | Invoice Not Paid | Invoice Not Paid |  |  |  |  |  |  |  | 2023-03-10 00:00:00 | 5793 | I1657 |  | Invoice Not Paid | Invoice Not Paid
 | I2263 | 2023-11-28 00:00:00 | 6842 |  |  |  |  |  |  |  | 2023-04-14 00:00:00 | 5910 | I1939 |  | 2023-11-28 00:00:00 | 6842
 | I2262 | Invoice Not Paid | Invoice Not Paid |  |  |  |  |  |  |  | 2023-04-21 00:00:00 | 5936 | I1970 |  | Invoice Not Paid | Invoice Not Paid
 | I2380 | Invoice Not Paid | Invoice Not Paid |  |  |  |  |  |  |  | 2023-04-28 00:00:00 | 5963 | I1855 |  | Invoice Not Paid | Invoice Not Paid
 | I2475 | Invoice Not Paid | Invoice Not Paid |  |  |  |  |  |  |  | 2023-05-05 00:00:00 | 5994 | I2080 |  | Invoice Not Paid | Invoice Not Paid
 | I2489 | 2023-11-28 00:00:00 | 6842 |  |  |  |  |  |  |  | 2023-05-19 00:00:00 | 6065 | I2184 |  | 2023-11-28 00:00:00 | 6842
 | I2476 | Invoice Not Paid | Invoice Not Paid |  |  |  |  |  |  |  | 2023-05-19 00:00:00 | 6065 | I2416 |  | Invoice Not Paid | Invoice Not Paid
 | I2626 | 2023-11-28 00:00:00 | 6842 |  |  |  |  |  |  |  | 2023-06-09 00:00:00 | 6150 | I2417 |  | 2023-11-28 00:00:00 | 6842
 | I2536 | Invoice Not Paid | Invoice Not Paid |  |  |  |  |  |  |  | 2023-07-07 00:00:00 | 6248 | I2589 |  | Invoice Not Paid | Invoice Not Paid
 | I2701 | 2023-11-28 00:00:00 | 6842 |  |  |  |  |  |  |  | 2023-07-07 00:00:00 | 6248 | I2715 |  | 2023-11-28 00:00:00 | 6842
 | I2793 | 2023-11-28 00:00:00 | 6842 |  |  |  |  |  |  |  | 2023-07-21 00:00:00 | 6309 | I2702 |  | 2023-11-28 00:00:00 | 6842
 | I2834 | 2023-08-18 00:00:00 | 6432 |  |  |  |  |  |  |  | 2023-07-28 00:00:00 | 6343 | I2858 |  | 2023-08-18 00:00:00 | 6432
 | I2904 | 2023-11-28 00:00:00 | 6842 |  |  |  |  |  |  |  | 2023-08-18 00:00:00 | 6432 | I2834 |  | 2023-11-28 00:00:00 | 6842
 | I2906 | 2023-11-28 00:00:00 | 6842 |  |  |  |  |  |  |  | 2023-08-25 00:00:00 | 6461 | I2792 |  | 2023-11-28 00:00:00 | 6842
 | I2905 | 2023-11-28 00:00:00 | 6842 |  |  |  |  |  |  |  | 2023-08-25 00:00:00 | 6461 | I3100 |  | 2023-11-28 00:00:00 | 6842
 | I3012 | Invoice Not Paid | Invoice Not Paid |  |  |  |  |  |  |  | 2023-09-15 00:00:00 | 6544 | I3298 |  | Invoice Not Paid | Invoice Not Paid
 | I3098 | 2023-11-28 00:00:00 | 6842 |  |  |  |  |  |  |  | 2023-09-28 00:00:00 | 6611 | I3288 |  | 2023-11-28 00:00:00 | 6842
 | I3100 | 2023-08-25 00:00:00 | 6461 |  |  |  |  |  |  |  | 2023-09-28 00:00:00 | 6611 | [NAME] |  | 2023-08-25 00:00:00 | 6461
 | I3099 | 2023-11-28 00:00:00 | 6842 |  |  |  |  |  |  |  | 2023-11-28 00:00:00 | 6842 | [NAME] |  | 2023-11-28 00:00:00 | 6842
 | I3158 | Invoice Not Paid | Invoice Not Paid |  |  |  |  |  |  |  | 2023-11-28 00:00:00 | 6842 | I1994 |  | Invoice Not Paid | Invoice Not Paid
 | I3160 | Invoice Not Paid | Invoice Not Paid |  |  |  |  |  |  |  | 2023-11-28 00:00:00 | 6842 | I2040 |  | Invoice Not Paid | Invoice Not Paid
 | I3159 | Invoice Not Paid | Invoice Not Paid |  |  |  |  |  |  |  | 2023-11-28 00:00:00 | 6842 | I2096 |  | Invoice Not Paid | Invoice Not Paid
 | I3263 | Invoice Not Paid | Invoice Not Paid |  |  |  |  |  |  |  | 2023-11-28 00:00:00 | 6842 | I2107 |  | Invoice Not Paid | Invoice Not Paid
 | I3288 | 2023-09-28 00:00:00 | 6611 |  |  |  |  |  |  |  | 2023-11-28 00:00:00 | 6842 | I2145 |  | 2023-09-28 00:00:00 | 6611
 | I3299 | 2023-11-28 00:00:00 | 6842 |  |  |  |  |  |  |  | 2023-11-28 00:00:00 | 6842 | I2252 |  | 2023-11-28 00:00:00 | 6842
 | I3298 | 2023-09-15 00:00:00 | 6544 |  |  |  |  |  |  |  | 2023-11-28 00:00:00 | 6842 | I2263 |  | 2023-09-15 00:00:00 | 6544
 | I3394 | 2023-11-28 00:00:00 | 6842 |  |  |  |  |  |  |  | 2023-11-28 00:00:00 | 6842 | I2489 |  | 2023-11-28 00:00:00 | 6842
 | I3396 | 2023-11-28 00:00:00 | 6842 |  |  |  |  |  |  |  | 2023-11-28 00:00:00 | 6842 | I2626 |  | 2023-11-28 00:00:00 | 6842
 | I3395 | 2023-11-28 00:00:00 | 6842 |  |  |  |  |  |  |  | 2023-11-28 00:00:00 | 6842 | I2701 |  | 2023-11-28 00:00:00 | 6842
 | I3668 | Invoice Not Paid | Invoice Not Paid |  |  |  |  |  |  |  | 2023-11-28 00:00:00 | 6842 | I2793 |  | Invoice Not Paid | Invoice Not Paid
 | I3678 | Invoice Not Paid | Invoice Not Paid |  |  |  |  |  |  |  | 2023-11-28 00:00:00 | 6842 | I2906 |  | Invoice Not Paid | Invoice Not Paid
 | I3680 | Invoice Not Paid | Invoice Not Paid |  |  |  |  |  |  |  | 2023-11-28 00:00:00 | 6842 | I2905 |  | Invoice Not Paid | Invoice Not Paid
 | I3679 | Invoice Not Paid | Invoice Not Paid |  |  |  |  |  |  |  | 2023-11-28 00:00:00 | 6842 | I2904 |  | Invoice Not Paid | Invoice Not Paid
 | I3676 | Invoice Not Paid | Invoice Not Paid |  |  |  |  |  |  |  | 2023-11-28 00:00:00 | 6842 | I3098 |  | Invoice Not Paid | Invoice Not Paid
 | I3675 | Invoice Not Paid | Invoice Not Paid |  |  |  |  |  |  |  | 2023-11-28 00:00:00 | 6842 | I3099 |  | Invoice Not Paid | Invoice Not Paid
 | I3674 | Invoice Not Paid | Invoice Not Paid |  |  |  |  |  |  |  | 2023-11-28 00:00:00 | 6842 | I3299 |  | Invoice Not Paid | Invoice Not Paid
 | I4030 | Invoice Not Paid | Invoice Not Paid |  |  |  |  |  |  |  | 2023-11-28 00:00:00 | 6842 | I3394 |  | Invoice Not Paid | Invoice Not Paid
 | I3931 | Invoice Not Paid | Invoice Not Paid |  |  |  |  |  |  |  | 2023-11-28 00:00:00 | 6842 | I3396 |  | Invoice Not Paid | Invoice Not Paid
 | I3933 | Invoice Not Paid | Invoice Not Paid |  |  |  |  |  |  |  | 2023-11-28 00:00:00 | 6842 | I3395 |  | Invoice Not Paid | Invoice Not Paid
 | I3932 | Invoice Not Paid | Invoice Not Paid |  |  |  |  |  |  |  |  |  |  |  | Invoice Not Paid | Invoice Not Paid
 | I3943 | Invoice Not Paid | Invoice Not Paid |  |  |  |  |  |  |  |  |  |  |  | Invoice Not Paid | Invoice Not Paid
 | I3945 | Invoice Not Paid | Invoice Not Paid |  |  |  |  |  |  |  |  |  |  |  | Invoice Not Paid | Invoice Not Paid
 | I3944 | Invoice Not Paid | Invoice Not Paid |  |  |  |  |  |  |  |  |  |  |  | Invoice Not Paid | Invoice Not Paid
 | I4333 | Invoice Not Paid | Invoice Not Paid |  |  |  |  |  |  |  |  |  |  |  | Invoice Not Paid | Invoice Not Paid
 | I4335 | Invoice Not Paid | Invoice Not Paid |  |  |  |  |  |  |  |  |  |  |  | Invoice Not Paid | Invoice Not Paid
 | I4334 | Invoice Not Paid | Invoice Not Paid |  |  |  |  |  |  |  |  |  |  |  | Invoice Not Paid | Invoice Not Paid
 | I4293 | Invoice Not Paid | Invoice Not Paid |  |  |  |  |  |  |  |  |  |  |  | Invoice Not Paid | Invoice Not Paid
 | I4301 | Invoice Not Paid | Invoice Not Paid |  |  |  |  |  |  |  |  |  |  |  | Invoice Not Paid | Invoice Not Paid
 | I4331 | Invoice Not Paid | Invoice Not Paid |  |  |  |  |  |  |  |  |  |  |  | Invoice Not Paid | Invoice Not Paid
 | I4332 | Invoice Not Paid | Invoice Not Paid |  |  |  |  |  |  |  |  |  |  |  | Invoice Not Paid | Invoice Not Paid