Compare two columns of similar values Check second list against master for new values

I have a set of values in Column A that are the Master List (A1:A301)

and a second set of values in Column C of which some are new. (C1:C98)

My goal is to discover which values are in Column C but not in Column A. Most of the C values are also in A, but a few are not and these are the ones I need.

I've tried =ISNA(MATCH but something is not quite right. I feel like this should be simple but I'm having difficulty.

Thank you

In cell D1 enter the formula =COUNTIF(A$1:A$301,C1) and copy down.
Any that result in 0 are NOT in column A.

Thank you very much. This worked.

If you don't mind would you please explain to me WHY it worked? Like a translation of the formula into plain language?

=COUNTIF(RangeToLookIn,ValueToLookFor)

So, "Range to look in" is your current list of values in column A and "Value to look for" is each individual value in the new list in column C. As you copy the formula down it will check each value in column C to see if it already appears in column A. If it does you get the number of times it appears and if it doesn't you get 0.

Does that help at all?

Yes. I know a little but not enough to understand from looking at the formula, and I don't like using tools I don't understand. You've cleared it up completely for me.

Thanks again.

Happy to help