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.


--
Demitre
------------------------------------------------------------------------
Demitre's Profile: http://www.excelforum.com/member.php...o&userid=29720
View this thread: http://www.excelforum.com/showthread...hreadid=494376