Two column comparison

[silvertabb]

In Column A (A2:A101) I have all lot numbers.
In Column B (B2:B20) I have the list of lots shipped.

What do I need?
In Column C (C2:C20) I need to include a formula or function to let me know whether or not entries in Column B have a match in Column A (i.e. there is not new lot in Column B).

Thanks,
Silvertabb

 

[texasalynn]

try a vlookup
=vlookup(b2,$A$2:$A$101,1,false)
copy that down

 

[Aladin Akyurek]

In Column A (A2:A101) I have all lot numbers.
In Column B (B2:B20) I have the list of lots shipped.

What do I need?
In Column C (C2:C20) I need to include a formula or function to let me know whether or not entries in Column B have a match in Column A (i.e. there is not new lot in Column B).

Thanks,
Silvertabb

C2, copy down:

=ISNUMBER(MATCH(B2,$A$2:$A$20,0))+0

1 stands for a hit, that is, lot shipped is available in column A; 0 stands for a no-hit.