Help fix a formula to return unmatched values

Hey guys

We have specific values in cell C36 to C43.

We want to match these against values in cell C1 to C34, and return the unmatched values.

So, we were given this formula to do so:

=IFERROR(INDEX(C:C, AGGREGATE(15,6,ROW(C$1:C$34)/(ISERROR(MATCH(C$1:C$34,C$36:C$43, 0))), ROWS(C$45:C45))),”")

Somehow it doesn’t work.

Please refer to the enclosed Excel file.

Can someone help fix it or suggest alternative?

(BTW, this is a simplified scenario. We are actually working on many rows, so best if the formula do not need to reference to all cells in column C, otherwise we would be prone to error.)

thank you very much!

Dear Bo_Ry
The formula appears to be working well.
Thank you very much !
Just to be sure, let me test it further before marking this thread solved.

Dear,

The formula works perfectly when there is one column of data to match against.
But then we try to add one more column of data, and use a defined name to cover both columns
Then we went into problem.
Would you be kind enough to take a look at the enclosed worksheet?
Thank you!!

Thank you again!
The formula seem to work.
There is one minor issue - when one of the matched values comes from the 2nd column, the formula always returns “zero”.
If there are further suggestion on how to handle this, I would be eager to know.

Bo_Ry, you have help me twice already.
Appreciated!
God bless.

Really great!
Thank you very much!