Try the below..I hope you are trying to retrieve the same value ...The third
argument is the number of column in the mentioned range...Here B:B has got
only one column

=VLOOKUP(B4,B!B:B,1,FALSE)

Or

=IF(ISERROR(MATCH(B4,B!B:B,0)),"Not in list","Found")

If this post helps click Yes
---------------
Jacob Skaria


"SMH" wrote:

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.