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

I'm not seeing how the second two columns match up. Can you clarify that?
"Demitre" wrote in
message ...

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

I don't mean match up as in they are the same. Only that they are in the
same set, like a name and address.

I think a solution might be to make a new column that just calls the Y
from collumn 1.. Is there a function that searches column 1 for X in
column 2 and shows the row below that X, which is Y?


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