Column A and B comparison

[silvertabb]

Hi
In Column A (all products) I have 200 lot number. In Column B (product shipped) I only have 30 lot numbers. I want to find out if all 30 lot numbers are included in Column A as well. What is the forumla I can use?

Here is what I am looking for:

Is cell B2 found in the range of A2:A101 in Column A?
thanks,

 

[pagrender]

Try this formula in C2 and drag down:

=IF(ISERROR(VLOOKUP(B2,$A$2:$A$101,1,FALSE)),"Not Included","Included")