What exactly do you mean by a match? For example:
If we are using cells A1:A10 and B1:B10, would be a match if the number '5'
appeared in A1 and B5? Or, would the number '5' have to appear in A1 and B1
to constitute a match?

If the match can be anywhere in the second column, this might do it:
=IF(ISNA(VLOOKUP(A1,$B$1:$B$10,1,0)),"No Match","Match")

If the match has to be in the same location:
=IF(A1=B1,"Match","No Match")

In both cases, copy down as far as needed.

tj

"Provider98122" wrote:

I need to compare the information in one column of an excel workbook to
another column of an excel workbook. Then need the system to report match or
non-match.

Thanks