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.
=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.