Using the IF and MATCH functions together

As the title says, I am wanting to create a formula that uses the IF and MATCH functions together.
Here is my current formula - =IFNA(IF(MATCH(A2,'1 1993-1997'!$A$2:$A$201,0,8),0)
I want a formula which says - if the value in A2 matches any of the values between A2:A201 in the previous sheet (1 1993-1997) then return 8, if not return 0. However, it currently doesn't work.
Any ideas?

How about

Formula:

Please Login or Register  to view this content.

The whole formula is actually this:
=IFNA(IF('2 1997-2001'!A2<>A2,0,IF(O2=4,"***",IF('1 1993-1997'!A2=A2,8,IF('2 1997-2001'!A2=A2,4)))),0)
Is there a way to make that work in this formula?

No idea, you haven't really given any details.