Broken formula

[KnAsTa]

Ok, vlookup again:

=IF(ISNUMBER(MATCH(A5,week1.xls!$A$1:$A$10,1)),IF(VLOOKUP(A5,week1.xls!$A$1:$C$10,3,0)>VLOOKUP(A5,week1.xls!$A$1:$D$10,4,0),1,0),

This first half works. Returns 1 and 0.

IF(VLOOKUP(A5,week1.xls!$A$1:$C$10,3,0)<VLOOKUP(A5,week1.xls!$A$1:$D$10,4,0),0,1))

The second half does not work, returns #N/A.

Still really confused. The first part only worked once i had put in the second half of the equation. Without the second part it gave me 1's and 0's which made no sense.

Can someone please explain this or show me the correct code.

 

[KnAsTa]

Sorry, scrap that question, now i need to know how to use a for loop in a formula.

=IF(ISNA(ISNUMBER(MATCH(A5,week1.xls!$A$1:$A$10,1))),IF(ISNA((VLOOKUP(A5,week1.xls!$A$1:$C$10,3,0)>VLOOKUP(A5,week1.xls!$A$1:$D$10,4,0))),1,0),IF(ISNA(VLOOKUP(A5,week1.xls!$A$1:$C$10,3,0)<VLOOKUP(A5,week1.xls!$A$1:$D$10,4,0)),0,1))

How would i get it to loop 19 times, ie, from week1.xls to week19.xls (19 external files)

Thanx