Hey,

I have this problem where I want to validate 2 set of data that aren't sorted and are in different format in excel.

Example of 1st set of data:
x3
y3
z3
x1
y1
x2
y2
z2

Example of second set:
x1 y1
x2 y2

What I want to do is have the 2nd set check each row for a matching X in set 1, and check the row beneath it to see if the Y also matches. In the first set, the corresponding Y is always the row below the X.

How would I go about doing this? I can use conditional formatting to see if the values of the 2nd set matches the values in the first, but I need something that matches it up. The values are strings.

Can anyone help me out?