Compare Columns and Display Results

Hello,

I would like to Compare Col A & B with Col C & D.

If the contents of Col A (format could be numbers, text, general) match Col C (in any format), then print Col A & B and C & D in another location next to each other.

If Col A does not match Col C (from C1, C2 to infinity), print Col A and the words "no match" next to it.

I need to check the contents of A1 with the contents of C1, C2 to infinity, then A2 will check C1, C2 to infinity until each row of Col A has been checked against each row of Col C.

CORRECTION OF DESCRIPTION APPEARS BELOW

Thanks for your help

I am not clear on what you want the result to look like, especially this: "print Col A & B and C & D in another location next to each other. "

But part of the solution is this formula, which for any row will tell you if the value in column A of that row can be found anywhere in column C:

Formula:

Please Login or Register  to view this content.

It would be helpful to attach a file with a small sample of what you want this to look like.

Thanks John, so do I just insert the code in any cell, populate ABC and D and that's it? Do I have to put the code in some special place and press something to get it to go? Thank you