Excel 2007 - Compare 2 columns, find the corresponding values

Question

I have two columns. Column A and column B, which have email addresses. Column A has about 3000 rows, column B has about 1800. Is there anyway to compare two columns and find any fields that match ...

And if so, how do you highlight or designate them as a match ... or shit, for the sake of simplicity just give me a count of the number of matches ...

Should I try a macro? Or is there a forum that will help with this?

Answer 1

You can fill column C with options using the following formula:

= IF (ERROR (MATCH (A1, $ B: $ B, 0)), "", A1)

Then C will contain only those values ​​that were in and C.

Answer 2

=VLOOKUP(lookup_value,table_array,col_index_num,range_lookup) .

.

Answer 3

VLOOKUP deosnt works for string literals