Im doing the same project as KnAsTa and I have similar problem with the formula.
=IF(ISNUMBER(MATCH(A5,week1.xls!$B$1:$B$10,0)),IF(VLOOKUP(A5,week1.xls!$A$1:$D$10,3,0)<VLOOKUP(A5,week1.xls!$A$1:$D$10,4,0),1,0),)
It will not work and instead it posts #N/A. THe formula works when the first bit is A1-A10 but not B. It should make no difference as the column B has similar results to A.
Any help would be greatly appreciated
Thanx
=IF(ISNUMBER(MATCH(A5,week1.xls!$B$1:$B$10,0)),IF(VLOOKUP(A5,week1.xls!$A$1:$D$10,3,0)<VLOOKUP(A5,week1.xls!$A$1:$D$10,4,0),1,0),)
It will not work and instead it posts #N/A. THe formula works when the first bit is A1-A10 but not B. It should make no difference as the column B has similar results to A.
Any help would be greatly appreciated
Thanx