Hi all
I have the following tables:
Table Account_Records which can have about 24k records depending on the day of the month (I have no control over this table).
Table Montior_File which can tell us if the customer was 'monitored' in that specific year. (A table I created).
The goal is to identify if the customers in the 'Account_Records' table were properly marked to be 'monitored' for that specific year that is in the Monitor_File table. I can't think of what formula (not sure if a macro is needed) would look at the rows/columns to do this.
Any guidance is welcomed.
I attached an excel file of what the end results should be (see column E).