VLOOKUP Error - EXCEL

I am trying to use VLOOKUP for the following: C开发者_开发技巧olumn A has all my data ids ( numbers) and Column B has a subset of my data ids in coulmn A

I need to get a list of all the ids which do not exist in Column B.

My VLOOKUP function looks like this:

= VLOOKUP(A1,B:B,2,FALSE)

I keep getting #N/A and #REF errors. I am not sure why.

Can some one please tell me what I am doing wrong. I am going on and on trying everything and nothing seems to be working.

Is my formula incorrect?

Thanks.

You're returning the 2nd column when your array is only 1 column. The 2 needs to be a 1.

=VLOOKUP(A2, B:B, 1, FALSE)