In Sheet1,
you had a "double" formula in A1 down which was incorrect, ie:
=IF(OR(Import!C1="",ISERROR(Import!C1+0)),"",IF(AN D(Import!C1+0=103000,Import!C1+0<=705999),Import! C1+ROW()/10^10,""))
=IF(OR(Import!C1="",ISERROR(Import!C1+0)),"",IF(AN D(Import!C1+0=103000,Import!C1+0<=705999),Import! C1+ROW()/10^10,""))

(How did you end up with the double w/o noticing it?)

Just delete away one of the double, ie correct it in A1 to:
=IF(OR(Import!C1="",ISERROR(Import!C1+0)),"",IF(AN D(Import!C1+0=103000,Import!C1+0<=705999),Import! C1+ROW()/10^10,""))
then copy A1 down, and the results will magically appear in col B
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,000 Files:370 Subscribers:66
xdemechanik
---
"Chad F" wrote in message
...
Max,

Here is my file. Please take a look and see if I am messing something up.
http://freefilehosting.net/download/440g5

Thanks,
Chad