Hello,

I am trying to validate the data in 3 columns. The 2nd 2 should match the first column.

Example 1st column: A
x2
y2
z3
x1
y1
z8
y8

example of 2: B
x1
x2
example of column 3: C
y1
y2

As you can see, column 2 and 3 matches up, and I want to validate that column 2's x1 is found in column 1, and the Y below that row is the same as the coresponding collumn 3. Collumn 1 isn't in any sort of order, so you'll have to search for it.

Something like Match(A:A:B1) and when match check match(Ax-1:C1), If not true, highlight the cell.