How to check matching strings in 3 columns

  • Thread starter Thread starter Demitre
  • Start date Start date
D

Demitre

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 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?
 
Back
Top