Better way to check data between tabs

[Nanaia]

Searching through the forum history I see others have had similar questions without an answer, but persistence prevails so here goes...
The CHECKER tab looks at the OrigCSV tab then at the RevCSV tab and says CHANGED if there is a difference between the two. A sample of the formula used is:

=IF(RevCSV!I2=OrigCSV!I2,"","CHANGED")

The relevant Original information is copied to the CHECKER tab in one column (for example, column A) with the next column (column B in the example) indicates whether the original information was changed in the revision.

The issue I'm running into is the RevCSV tab sometimes has lines added or removed in the middle so everything after those additions/removals will show CHANGED because the formula looks at row 2 in the ORIG tab and compares is to row 2 in the REV tab. Is there a way to have it look at the reference cell in the CHECKER tab (column A) and have it search the entire column in the RevCSV tab to find the data instead of only a specific row? Then carry the search across to the other columns? Goodness that sounds terrible. I hope it makes at least a little sense. I've managed to get XL2BB on the computer and copied the tabs for examples in hopes that it helps.

CSV Checker.xlsx
	A
1
CHECKER

CSV Checker.xlsx
	A
1	OPF ID
OrigCSV

CSV Checker.xlsx
	T
9	19.189
RevCSV

 

[BSALV]

can you use the match-function and check within a range ?

20220224_01.xlsm
	I
2	okay
Blad2

Cell Formulas
Range	Formula
I2	I2	=IF(ISNUMBER(MATCH(REVcsv!I2,OrigCSV!$I$1:$I$1000,0)),"okay","CHANGED")

 

[Nanaia]

can you use the match-function and check within a range ?

20220224_01.xlsm
	I
2	okay
Blad2

Cell Formulas
Range	Formula
I2	I2	=IF(ISNUMBER(MATCH(REVcsv!I2,OrigCSV!$I$1:$I$1000,0)),"okay","CHANGED")

@BSALV That works for column B on the checker. Do you have any suggestions on how that would be incorporated into the other columns? The Mark number (column A in the checker) would be the linchpin. No matter what row the mark number is in on the RevCSV the information needs to be checked against the original. Would IFS accomplish that? Or maybe IFS AND?