How to check matching strings in 3 columns

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.

I'm not seeing how the second two columns match up. Can you clarify that?
"Demitre" <[email protected]> wrote in
message news:[email protected]...
>
> 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?