My function matches the variable in cel R[1]C[-1] with variables in a matrix IsEen and gives back variable 2 when match is true and zero when match is wrong. But it gives me SyntaxError. Can somebody help me fix this function?
VB Code:
Function LookColumnBackAndRowFuther() If(16<>Type(MATCH(R[1]C[-1],IsEen,0)),2,0) End Function




Reply With Quote