Shouldn't this be

NOT_IN = Application.IsNA(Application.Match(value, range, 0))



"Sanz" wrote:

Hi All

Was wondering if you could help me, I have the following function:

Function NOT_IN(value, range)


NOT_IN = Application.IsNA(Application.Match(1, "C6:j6", 0))

End Function

The Function reads False in the cell no matter what I do, can anyone help??