In C1, try something like;

=--(COUNTIF($D$1:$D$8,A1)0)*B1

or
=IF(COUNTIF($D$1:$D$8,A1)0,B1,0)



"Turi" wrote in 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!