Spreadsheet: 760201d1640055247-vlookup-formula-lookup-value-and-lookup-vector-are-in-the-same-range-book100
Sheet: Sheet1

Month | Register Number | status | result | Month2 | Result2 |  | This Month | 202104 |  |  |  |  |  | Output
202103 | 67269862 | 80 |  |  |  |  | Last Month |  |  |  |  |  |  | Month | Register Number | status | result
202103 | 67269966 | 80 |  |  |  |  |  |  |  |  |  |  |  | 202103 | 67269862 | 80 | 80
202103 | 67278451 | 80 |  |  |  |  |  |  |  |  |  |  |  | 202103 | 67269966 | 80 | 90
202103 | 67277463 | 80 |  |  |  |  |  |  |  |  |  |  |  | 202103 | 67278451 | 80 | Deleted
202103 | 67282907 | 70 |  |  |  |  |  |  |  |  |  |  |  | 202103 | 67277463 | 80 | 90
202103 | 67296354 | 80 |  |  |  |  |  |  |  |  |  |  |  | 202103 | 67282907 | 70 | 90
202103 | 67306098 | 90 |  |  |  |  |  |  |  |  |  |  |  | 202103 | 67296354 | 80 | 60
202103 | 67306100 | 80 |  |  |  |  |  |  |  |  |  |  |  | 202103 | 67306098 | 90 | 90
202103 | 67324702 | 90 |  |  |  |  |  |  |  |  |  |  |  | 202103 | 67306100 | 80 | 60
202103 | 67324704 | 80 |  |  |  |  |  |  |  |  |  |  |  | 202103 | 67324702 | 90 | 80
202103 | 67362986 | 80 |  |  |  |  |  |  |  |  |  |  |  | 202103 | 67324704 | 80 | 45
202103 | 67363044 | 80 |  |  |  |  |  |  |  |  |  |  |  | 202103 | 67362986 | 80 | 90
202103 | 67366479 | 80 |  |  |  |  |  |  |  |  |  |  |  | 202103 | 67363044 | 80 | 90
202103 | 62368435 | 90 |  |  |  |  |  |  |  |  |  |  |  | 202103 | 67366479 | 80 | 70
202103 | 67368439 | 90 |  |  |  |  |  |  |  |  |  |  |  | 202103 | 62368435 | 90 | Deleted
202103 | 67368440 | 40 |  |  |  |  |  |  |  |  |  |  |  | 202103 | 67368439 | 90 | 70
202103 | 67368443 | 90 |  |  |  |  |  |  |  |  |  |  |  | 202103 | 67368440 | 40 | 70
202103 | 67368444 | 90 |  |  |  |  |  |  |  |  |  |  |  | 202103 | 67368443 | 90 | 70
202103 | 67368445 | 60 |  |  |  |  |  |  |  |  |  |  |  | 202103 | 67368444 | 90 | 90
202103 | 87368446 | 90 |  |  |  |  |  |  |  |  |  |  |  | 202103 | 67368445 | 60 | 70
202104 | 67269862 | 80 |  |  |  |  |  |  |  |  |  |  |  | 202103 | 87368446 | 90 | Deleted
202104 | 67269966 | 90 |  |  |  |  |  |  |  |  |  |  |  | 202104 | 67269862 | 80 | 80
202104 | 67277451 | 70 |  |  |  |  |  |  |  |  |  |  |  | 202104 | 67269966 | 90 | 80
202104 | 67277463 | 90 |  |  |  |  |  |  |  |  |  |  |  | 202104 | 67277451 | 70 | #N/A
202104 | 67282907 | 90 |  |  |  |  |  |  |  |  |  |  |  | 202104 | 67277463 | 90 | 80
202104 | 67296354 | 60 |  |  |  |  |  |  |  |  |  |  |  | 202104 | 67282907 | 90 | 70
202104 | 67306098 | 90 |  |  |  |  |  |  |  |  |  |  |  | 202104 | 67296354 | 60 | 80
202104 | 67306100 | 60 |  |  |  |  |  |  |  |  |  |  |  | 202104 | 67306098 | 90 | 90
202104 | 67324702 | 80 |  |  |  |  |  |  |  |  |  |  |  | 202104 | 67306100 | 60 | 80
202104 | 67324704 | 45 |  |  |  |  |  |  |  |  |  |  |  | 202104 | 67324702 | 80 | 90
202104 | 67362986 | 90 |  |  |  |  |  |  |  |  |  |  |  | 202104 | 67324704 | 45 | 80
202104 | 67363044 | 90 |  |  |  |  |  |  |  |  |  |  |  | 202104 | 67362986 | 90 | 80
202104 | 67366479 | 70 |  |  |  |  |  |  |  |  |  |  |  | 202104 | 67363044 | 90 | 80
202104 | 67368435 | 80 |  |  |  |  |  |  |  |  |  |  |  | 202104 | 67366479 | 70 | 80
202104 | 67368439 | 70 |  |  |  |  |  |  |  |  |  |  |  | 202104 | 67368435 | 80 | #N/A
202104 | 67368440 | 70 |  |  |  |  |  |  |  |  |  |  |  | 202104 | 67368439 | 70 | 90
202104 | 67368443 | 70 |  |  |  |  |  |  |  |  |  |  |  | 202104 | 67368440 | 70 | 40
202104 | 67368444 | 90 |  |  |  |  |  |  |  |  |  |  |  | 202104 | 67368443 | 70 | 90
202104 | 67368445 | 70 |  |  |  |  |  |  |  |  |  |  |  | 202104 | 67368444 | 90 | 90
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 202104 | 67368445 | 70 | 60