Column C may contain values that are not in A.
and
look at the values in A, check to see if the values is in C, and if it is not, copy the value to the next available row in C.
If c contains all A, the missing must be in column A. You should return what is in C, but in A to A.
I also do not understand why can not you use a simple Vlookup formula.
Bookmarks