Spreadsheet: 880435d1728166016-some-combination-of-lookup-and-match-needed-ehf-10-05-2024-lookup-formula
Sheet: add back Div & Div Pay Date

 |  |  |  |  |  |  |  |  |  |  |  |  |  | dividends | unique tickers |  |  | red
 |  |  |  |  |  |  |  | Table 2
 |  |  |  |  |  |  |  |  |  | Fundamentals |  |  |  |  |  |  |  | green
Table 1 |  |  |  |  |  |  |  |  |  |  | dividends |  | unique tickers |  |  |  |  | yellow |  |  |  | Past Values |  |  | [NAME]
Symbol | Div.ExDate | Buy Date (Ex-Date - 1 Trade Date) | New.Amount | Div.PayDate |  |  |  |  | Buy Date |  | passing both |  | passing both |  |  |  |  | na |  |  |  | New.Amount | Div.PayDate |  | New.Amount | Div.PayDate
DivInv | DivInv |  | DivInv | DivInv
AAME | 2023-08-21 00:00:00 | 2023-08-18 00:00:00 | 0.02 | 2023-09-12 00:00:00 |  |  |  | AAT | 2021-12-07 00:00:00 | y |  |  |  |  |  |  |  |  |  |  |  | 0.3 | 2021-12-23 00:00:00
AAN | 2022-09-14 00:00:00 | 2022-09-13 00:00:00 | 0.1125 | 2022-10-04 00:00:00 |  |  |  | AB | 2021-02-18 00:00:00 | y |  |  |  |  |  |  |  |  |  |  |  | 0.97 | 2021-03-04 00:00:00
AAN | 2022-12-14 00:00:00 | 2022-12-13 00:00:00 | 0.1125 | 2023-01-05 00:00:00 |  |  |  | AB | 2021-08-05 00:00:00 | y |  |  |  |  |  |  |  |  |  |  |  | 0.91 | 2021-08-19 00:00:00
AAN | 2023-03-15 00:00:00 | 2023-03-14 00:00:00 | 0.125 | 2023-04-04 00:00:00 |  |  |  | ABBV | 2021-04-13 00:00:00 | y |  |  |  |  |  |  |  |  |  |  |  | 1.3 | 2021-05-14 00:00:00
AAN | 2023-06-14 00:00:00 | 2023-06-13 00:00:00 | 0.125 | 2023-07-06 00:00:00 |  |  |  | ABBV | 2021-10-13 00:00:00 | y |  |  |  |  |  |  |  |  |  |  |  | 1.3 | 2021-11-15 00:00:00
AAN | 2023-09-13 00:00:00 | 2023-09-12 00:00:00 | 0.125 | 2023-10-04 00:00:00 |  |  |  | ABBV | 2022-01-12 00:00:00 | y |  |  |  |  |  |  |  |  |  |  |  | 1.41 | 2022-02-15 00:00:00
AAN | 2023-12-13 00:00:00 | 2023-12-12 00:00:00 | 0.125 | 2024-01-04 00:00:00 |  |  |  | ABBV | 2023-01-11 00:00:00 | y |  |  |  |  |  |  |  |  |  |  |  | 1.48 | 2023-02-15 00:00:00
AAP | 2022-03-17 00:00:00 | 2022-03-16 00:00:00 | 1.5 | 2022-04-01 00:00:00 |  |  |  |  |  | y
AAP | 2022-06-16 00:00:00 | 2022-06-15 00:00:00 | 1.5 | 2022-07-01 00:00:00 |  |  |  |  |  | y
AAP | 2022-09-15 00:00:00 | 2022-09-14 00:00:00 | 1.5 | 2022-09-30 00:00:00 |  |  |  |  |  | y
AAP | 2022-12-15 00:00:00 | 2022-12-14 00:00:00 | 1.5 | 2023-01-03 00:00:00 |  |  |  |  |  | y
AAP | 2023-04-13 00:00:00 | 2023-04-12 00:00:00 | 1.5 | 2023-04-28 00:00:00 |  |  |  |  |  | y
AAT | 2021-03-10 00:00:00 | 2021-03-09 00:00:00 | 0.28 | 2021-03-25 00:00:00 |  |  |  |  |  | y
AAT | 2021-06-09 00:00:00 | 2021-06-08 00:00:00 | 0.28 | 2021-06-24 00:00:00 |  |  |  |  |  | y
AAT | 2021-09-08 00:00:00 | 2021-09-07 00:00:00 | 0.3 | 2021-09-23 00:00:00 |  |  |  |  |  | y
AAT | 2021-12-08 00:00:00 | 2021-12-07 00:00:00 | 0.3 | 2021-12-23 00:00:00 |  |  |  |  |  | y
AAT | 2022-03-09 00:00:00 | 2022-03-08 00:00:00 | 0.32 | 2022-03-24 00:00:00 |  |  |  |  |  | y
AAT | 2022-06-08 00:00:00 | 2022-06-07 00:00:00 | 0.32 | 2022-06-23 00:00:00 |  |  |  |  |  | y
AAT | 2022-09-07 00:00:00 | 2022-09-06 00:00:00 | 0.32 | 2022-09-22 00:00:00 |  |  |  |  |  | y
AAT | 2022-12-07 00:00:00 | 2022-12-06 00:00:00 | 0.32 | 2022-12-22 00:00:00 |  |  |  |  |  | y
AAT | 2023-03-08 00:00:00 | 2023-03-07 00:00:00 | 0.33 | 2023-03-23 00:00:00 |  |  |  |  |  | y
AAT | 2023-06-07 00:00:00 | 2023-06-06 00:00:00 | 0.33 | 2023-06-22 00:00:00 |  |  |  |  |  | y
AAT | 2023-09-06 00:00:00 | 2023-09-05 00:00:00 | 0.33 | 2023-09-21 00:00:00 |  |  |  |  |  | y
AAT | 2023-12-06 00:00:00 | 2023-12-05 00:00:00 | 0.33 | 2023-12-21 00:00:00 |  |  |  |  |  | y
AB | 2021-02-19 00:00:00 | 2021-02-18 00:00:00 | 0.97 | 2021-03-04 00:00:00 |  |  |  |  |  | y
AB | 2021-05-07 00:00:00 | 2021-05-06 00:00:00 | 0.81 | 2021-05-27 00:00:00 |  |  |  |  |  | y
AB | 2021-08-06 00:00:00 | 2021-08-05 00:00:00 | 0.91 | 2021-08-19 00:00:00 |  |  |  |  |  | y
AB | 2021-11-05 00:00:00 | 2021-11-04 00:00:00 | 0.89 | 2021-11-24 00:00:00 |  |  |  |  |  | y
AB | 2022-02-18 00:00:00 | 2022-02-17 00:00:00 | 1.29 | 2022-03-17 00:00:00 |  |  |  |  |  | y
AB | 2022-05-06 00:00:00 | 2022-05-05 00:00:00 | 0.9 | 2022-05-26 00:00:00 |  |  |  |  |  | y
AB | 2022-08-05 00:00:00 | 2022-08-04 00:00:00 | 0.71 | 2022-08-18 00:00:00 |  |  |  |  |  | y
AB | 2022-11-04 00:00:00 | 2022-11-03 00:00:00 | 0.64 | 2022-11-23 00:00:00 |  |  |  |  |  | y
AB | 2023-02-17 00:00:00 | 2023-02-16 00:00:00 | 0.7 | 2023-03-16 00:00:00 |  |  |  |  |  | y
AB | 2023-05-05 00:00:00 | 2023-05-04 00:00:00 | 0.66 | 2023-05-25 00:00:00 |  |  |  |  |  | y
AB | 2023-08-04 00:00:00 | 2023-08-03 00:00:00 | 0.61 | 2023-08-17 00:00:00 |  |  |  |  |  | y
AB | 2023-11-03 00:00:00 | 2023-11-02 00:00:00 | 0.65 | 2023-11-22 00:00:00 |  |  |  |  |  | y
ABBV | 2021-01-14 00:00:00 | 2021-01-13 00:00:00 | 1.3 | 2021-02-16 00:00:00 |  |  |  |  |  | y
ABBV | 2021-04-14 00:00:00 | 2021-04-13 00:00:00 | 1.3 | 2021-05-14 00:00:00 |  |  |  |  |  | y
ABBV | 2021-07-14 00:00:00 | 2021-07-13 00:00:00 | 1.3 | 2021-08-16 00:00:00 |  |  |  |  |  | y
ABBV | 2021-10-14 00:00:00 | 2021-10-13 00:00:00 | 1.3 | 2021-11-15 00:00:00 |  |  |  |  |  | y
ABBV | 2022-01-13 00:00:00 | 2022-01-12 00:00:00 | 1.41 | 2022-02-15 00:00:00 |  |  |  |  |  | y
ABBV | 2022-04-13 00:00:00 | 2022-04-12 00:00:00 | 1.41 | 2022-05-16 00:00:00 |  |  |  |  |  | y
ABBV | 2022-07-14 00:00:00 | 2022-07-13 00:00:00 | 1.41 | 2022-08-15 00:00:00 |  |  |  |  |  | y
ABBV | 2022-10-13 00:00:00 | 2022-10-12 00:00:00 | 1.41 | 2022-11-15 00:00:00 |  |  |  |  |  | y
ABBV | 2023-01-12 00:00:00 | 2023-01-11 00:00:00 | 1.48 | 2023-02-15 00:00:00 |  |  |  |  |  | y
ABBV | 2023-04-13 00:00:00 | 2023-04-12 00:00:00 | 1.48 | 2023-05-15 00:00:00 |  |  |  |  |  | y
ABBV | 2023-07-13 00:00:00 | 2023-07-12 00:00:00 | 1.48 | 2023-08-15 00:00:00 |  |  |  |  |  | y
ABBV | 2023-10-12 00:00:00 | 2023-10-11 00:00:00 | 1.48 | 2023-11-15 00:00:00 |  |  |  |  |  | y