Spreadsheet: 838278d1690892148-entering-data-into-joined-tables-stuck
Sheet: Sheet1

 | Invoice Table |  |  |  |  |  |  | Invoice Data Table
 | Invoice Number | Invoice Date | Invoice Amount | Amount Remaining |  |  |  | Invoice Number | Retainage | Notes | Invoice Item
 | 1001 | 2023-01-01 00:00:00 | 9622 | 100 |  |  |  | 1001 | No | Slow Pay | a
 | 1002 | 2023-02-01 00:00:00 | 7559 | 2277 |  |  |  | 1002 | No | Slow Pay | b
 | 1003 | 2023-02-02 00:00:00 | 1927 | 1927 |  |  |  | 1003 | No | Slow Pay | c
 | 1004 | 2023-04-10 00:00:00 | 1636 | 1636 |  |  |  | 1004 | No | Nice Customer | d
 | 1005 | 1912-09-05 00:00:00 | 1618 | 1618 |  |  |  | 1005 | No | Checks in the mail | a
 | 1006 | 1911-11-09 00:00:00 | 4896 | 2000 |  |  |  | 1006 | Yes | haha | b
 | 1007 | 1904-12-04 00:00:00 | 7529 | 1000 |  |  |  | 1007 | Yes | Checks in the mail | c
 | 1008 | 1922-05-15 00:00:00 | 1106 | 0 |  |  |  | 1008 | No | Checks in the mail | d
 | 1009 | 1903-03-26 00:00:00 | 1214 | 1214 |  |  |  | 1009 | Yes | Checks in the mail | a
 | 1010 | 1917-05-03 00:00:00 | 6576 | 0 |  |  |  | 1010 | No | Repeat | b
 | 1011 | 1925-01-06 00:00:00 | 4331 | 0 |  |  |  | 1011 | No | No notes | c
 | 1012 | 1923-09-24 00:00:00 | 8910 | 0 |  |  |  | 1012 | Yes | Repeat | d
 | 1013 | 1920-11-27 00:00:00 | 4828 | 4200 |  |  |  | 1013 | No | No notes | a
 | 1014 | 1907-06-07 00:00:00 | 2097 | 1000 |  |  |  | 1014 | No | Repeat | b
 | 1015 | 1913-07-28 00:00:00 | 4140 | 500 |  |  |  | 1015 | No | No notes | c
 | 1016 | 1917-03-29 00:00:00 | 2374 | 0 |  |  |  | 1016 | No | Repeat | d
 | 1017 | 1926-04-06 00:00:00 | 2164 | 0 |  |  |  | 1017 | No | No notes | a
 | 1018 | 1914-10-08 00:00:00 | 9576 | 1 |  |  |  | 1018 | No | Repeat | b
 | 1019 | 1909-09-01 00:00:00 | 7785 | 0 |  |  |  | 1019 | No | No notes | c
 | Vlookup doesn’t work because its just reporting from the 2nd table
 |  | 44927 | 9622 | 100
 | 1002 | 44958 | 7559 | 2277
 | 1003 | 44959 | 1927 | 1927
 | 1004 | 45026 | 1636 | 1636
 | 1005 | 4632 | 1618 | 1618
 | 1006 | 4331 | 4896 | 2000
 | 1007 | 1800 | 7529 | 1000
 | 1008 | 8171 | 1106 | 0
 | 1009 | 1181 | 1214 | 1214
 | 1010 | 6333 | 6576 | 0
 | 1011 | 9138 | 4331 | 0
 | 1012 | 8668 | 8910 | 0
 | 1013 | 7637 | 4828 | 4200
 | 1014 | 2715 | 2097 | 1000
 | 1015 | 4958 | 4140 | 500
 | 1016 | 6298 | 2374 | 0
 | 1017 | 9593 | 2164 | 0
 | 1018 | 5395 | 9576 | 1
 | 1019 | 3532 | 7785 | 0
 | Same with Pivot Table. It reports but can't change the original table
Invoice Number | Invoice Date | Notes | Sum of Invoice Amount
1001 | 2023-01-01 00:00:00 | Slow Pay | 9622
1002 | 2023-02-01 00:00:00 | Slow Pay | 7559
1003 | 2023-02-02 00:00:00 | Slow Pay | 1927
1004 | 2023-04-10 00:00:00 | Nice Customer | 1636
1005 | 1912-09-05 00:00:00 | Checks in the mail | 1618
1006 | 1911-11-09 00:00:00 | haha | 4896
1007 | 1904-12-04 00:00:00 | Checks in the mail | 7529
1008 | 1922-05-15 00:00:00 | Checks in the mail | 1106
1009 | 1903-03-26 00:00:00 | Checks in the mail | 1214
1010 | 1917-05-03 00:00:00 | Repeat | 6576
1011 | 1925-01-06 00:00:00 | No notes | 4331
1012 | 1923-09-24 00:00:00 | Repeat | 8910
1013 | 1920-11-27 00:00:00 | No notes | 4828
1014 | 1907-06-07 00:00:00 | Repeat | 2097
1015 | 1913-07-28 00:00:00 | No notes | 4140
1016 | 1917-03-29 00:00:00 | Repeat | 2374
1017 | 1926-04-06 00:00:00 | No notes | 2164
1018 | 1914-10-08 00:00:00 | Repeat | 9576
1019 | 1909-09-01 00:00:00 | No notes | 7785
Grand Total |  |  | 89888