mtkalman
02-22-2017, 01:52 AM
Hey there!
So i have the folloving problem.
I have two lists in two different worksheets, and already compared them, marking the differences.
The list looks something like:
ABC-12345 in cell B1 a few irrelevant cells and then 1234 in H1
ABC-12346 in cell B2 a few irrelevant cells and then 1235 in H2
And a list with the same structure in another worksheet. What i need is if the ABC-12345 has a matching value in the other list, check if the related four digit number few cells away is
matching as well.
Anyone knows something like that?
So i have the folloving problem.
I have two lists in two different worksheets, and already compared them, marking the differences.
The list looks something like:
ABC-12345 in cell B1 a few irrelevant cells and then 1234 in H1
ABC-12346 in cell B2 a few irrelevant cells and then 1235 in H2
And a list with the same structure in another worksheet. What i need is if the ABC-12345 has a matching value in the other list, check if the related four digit number few cells away is
matching as well.
Anyone knows something like that?