Searching/Matching Data

[silvertabb]

hi
in my excel spreadsheet I have Column A that contains 60 lot numbers. In column C I have over 1000 lot #. In column I want to use a function that looks up the entire range of lot numbers in Column C for each entry in Column A and to return "Yes included in Column C" or "No not in Column C".

thanks

 

[mikerickson]

A formula like
=IF(ISNUMBER(MATCH(A1,C:C,0)), "Yes included ", "No not ")&"in Column C."