Try this instead:

=IF(ISNA(MATCH(A1,D1:D8,0)),0,B1)

HTH
Jason
Atlanta, GA

-----Original Message-----
I currently have created an if statement with 7 nested
if statements. I now
need to add another if statement, but there is a limit
of 7 nested
statements. Is there a work around.

My issue is that I want to copy the # in cell B1 to cell
C1 only if cell A1
matches one of the 8 values in column D (D1:D8), if not
return a value of 0.

The if statement worked for 7 values, but now I have 8.
Please help
Thanks!
.