Excel 2007 : ISNA and Vlookup help

I have created a spreadsheet that should auto generate a lot of information and I'm running into an issue. The cells in question are C4 and D4. Cell C4 reads, =IF(ISNA(VLOOKUP(A4,'TCM Data'!$A$2:$C$664,3,FALSE)),"0",VLOOKUP(A4,'TCM Data'!$A$2:$C$664,3,FALSE)). This pulls data from the TCM tab the is pasted in from another spreadsheet. from here column O reads, =IF(C4>700, 7,IF(C4>600,6, IF(C4>500,5,IF(C4>400,4,IF(C4>300,3,IF(C4>200,2,IF(C4>100,1,0))))))). The issue that I am having is that when there are no occurrences and the Value $ reads 0, the O column returns a value of 7 when it should read 0. I cannot figure out why.

Also, D4 has a similar formula as C4 which is, =IF(ISNA(VLOOKUP('CU Data'!A3,'CU Data'!$B$3:$B$200,3,FALSE)), "0",VLOOKUP('CU Data'!A3,'CU Data'!$B$3:$B$200,3,FALSE)). Here I am getting a bad reference and don't know why...

I have attached the spreadsheet if that helps...

Please help!!!!

For the first issue.....

You are using a value of "0" when VLOOKUP returns #N/A. Using quotes turns zero into a text value which is deemed to be greater than any number. Use just 0......or in Excel 2007 you could use IFERROR function to avoid repeating the VLOOKUP, i.e.

=IFERROR(VLOOKUP(A4,'TCM Data'!$A$2:$C$664,3,FALSE),0)

for the second......

Your lookup table is a single column, i.e. 'CU Data'!$B$3:$B$200, as your column index is 3 this presumably should be something like 'CU Data'!$B$3:$D$200

Perfect! Guess that was an easy one...