Try this:

List1 in the range Sheet A A1:A10
List2 in the range Sheet B A1:A10

Enter this formula on Sheet A B1:

=IF(COUNTIF(B!A$1:A$10,A1),"x","")

Copy down as needed. Cells that return "x" denote a match. If one list is
shorter than the other then compare the shorter list against the longer
list.

--
Biff
Microsoft Excel MVP


"SMH" wrote in message
...
Good evening- I am trying to take two lists and finding the matching
values
on both lists. I have tried using vlookup, but haven't had much luck. Is
that the right function to use? What is the difference between vlookup
and
lookup?

Here is what I've got- two worksheets (A and B).
=VLOOKUP(B4,B!B:B,2,FALSE)

Any help would be greatly appreciated!

Thank you.