Spreadsheet: 760200d1640054262-vlookup-formula-lookup-value-and-lookup-vector-are-in-the-same-range-book100-bvj-
Sheet: Sheet1

Month | Register Number | status | result |  |  |  |  |  |  |  |  |  | Month | Register Number | status | result
202111 | 67269862 | 80 |  |  |  |  |  |  |  |  |  |  | 202103 | 67269862 | 80 | 80
202111 | 67269966 | 80 |  |  |  |  |  |  |  |  |  |  | 202103 | 67269966 | 80 | 90
202111 | 67278451 | 80 |  |  |  |  |  |  |  |  |  |  | 202103 | 67278451 | 80 | Deleted
202111 | 67277463 | 80 |  |  |  |  |  |  |  |  |  |  | 202103 | 67277463 | 80 | 90
202111 | 67282907 | 70 |  |  |  |  |  |  |  |  |  |  | 202103 | 67282907 | 70 | 90
202111 | 67296354 | 80 |  |  |  |  |  |  |  |  |  |  | 202103 | 67296354 | 80 | 60
202111 | 67306098 | 90 |  |  |  |  |  |  |  |  |  |  | 202103 | 67306098 | 90 | 90
202111 | 67306100 | 80 |  |  |  |  |  |  |  |  |  |  | 202103 | 67306100 | 80 | 60
202111 | 67324702 | 90 |  |  |  |  |  |  |  |  |  |  | 202103 | 67324702 | 90 | 80
202111 | 67324704 | 80 |  |  |  |  |  |  |  |  |  |  | 202103 | 67324704 | 80 | 45
202111 | 67362986 | 80 |  |  |  |  |  |  |  |  |  |  | 202103 | 67362986 | 80 | 90
202111 | 67363044 | 80 |  |  |  |  |  |  |  |  |  |  | 202103 | 67363044 | 80 | 90
202111 | 67366479 | 80 |  |  |  |  |  |  |  |  |  |  | 202103 | 67366479 | 80 | 70
202111 | 62368435 | 90 |  |  |  |  |  |  |  |  |  |  | 202103 | 62368435 | 90 | Deleted
202111 | 67368439 | 90 |  |  |  |  |  |  |  |  |  |  | 202103 | 67368439 | 90 | 70
202111 | 67368440 | 40 |  |  |  |  |  |  |  |  |  |  | 202103 | 67368440 | 40 | 70
202111 | 67368443 | 90 |  |  |  |  |  |  |  |  |  |  | 202103 | 67368443 | 90 | 70
202111 | 67368444 | 90 |  |  |  |  |  |  |  |  |  |  | 202103 | 67368444 | 90 | 90
202111 | 67368445 | 60 |  |  |  |  |  |  |  |  |  |  | 202103 | 67368445 | 60 | 70
202111 | 87368446 | 90 |  |  |  |  |  |  |  |  |  |  | 202103 | 87368446 | 90 | Deleted
202112 | 67269862 | 80 |  |  |  |  |  |  |  |  |  |  | 202104 | 67269862 | 80 | 80
202112 | 67269966 | 90 |  |  |  |  |  |  |  |  |  |  | 202104 | 67269966 | 90 | 80
202112 | 67277451 | 70 |  |  |  |  |  |  |  |  |  |  | 202104 | 67277451 | 70 | #N/A
202112 | 67277463 | 90 |  |  |  |  |  |  |  |  |  |  | 202104 | 67277463 | 90 | 80
202112 | 67282907 | 90 |  |  |  |  |  |  |  |  |  |  | 202104 | 67282907 | 90 | 70
202112 | 67296354 | 60 |  |  |  |  |  |  |  |  |  |  | 202104 | 67296354 | 60 | 80
202112 | 67306098 | 90 |  |  |  |  |  |  |  |  |  |  | 202104 | 67306098 | 90 | 90
202112 | 67306100 | 60 |  |  |  |  |  |  |  |  |  |  | 202104 | 67306100 | 60 | 80
202112 | 67324702 | 80 |  |  |  |  |  |  |  |  |  |  | 202104 | 67324702 | 80 | 90
202112 | 67324704 | 45 |  |  |  |  |  |  |  |  |  |  | 202104 | 67324704 | 45 | 80
202112 | 67362986 | 90 |  |  |  |  |  |  |  |  |  |  | 202104 | 67362986 | 90 | 80
202112 | 67363044 | 90 |  |  |  |  |  |  |  |  |  |  | 202104 | 67363044 | 90 | 80
202112 | 67366479 | 70 |  |  |  |  |  |  |  |  |  |  | 202104 | 67366479 | 70 | 80
202112 | 67368435 | 80 |  |  |  |  |  |  |  |  |  |  | 202104 | 67368435 | 80 | #N/A
202112 | 67368439 | 70 |  |  |  |  |  |  |  |  |  |  | 202104 | 67368439 | 70 | 90
202112 | 67368440 | 70 |  |  |  |  |  |  |  |  |  |  | 202104 | 67368440 | 70 | 40
202112 | 67368443 | 70 |  |  |  |  |  |  |  |  |  |  | 202104 | 67368443 | 70 | 90
202112 | 67368444 | 90 |  |  |  |  |  |  |  |  |  |  | 202104 | 67368444 | 90 | 90
202112 | 67368445 | 70 |  |  |  |  |  |  |  |  |  |  | 202104 | 67368445 | 70 | 60
 |  |  |  |  |  |  |  |  |  |  |  |  |  | current_month | =INDEX(Sheet1!$A:$A,current_month_row):INDEX(Sheet1!$C:$C,MATCH([PHONE],Sheet1!$C:$C))
 |  |  |  |  |  |  |  |  |  |  |  |  |  | current_month_row | =Sheet1!$T$1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Previous_Month | =Sheet1!$A$2:INDEX(Sheet1!$C:$C,current_month_row-1)