Hi, i posted this earlier on, but my problem didnt really get clarified awefully well. I was wondering if someone would be kind enough to show me the right code for this formula. Its not working completely write. Its not syntactically wrong, no errors are occuring, except within the cells. Here is the code:
=IF(ISNUMBER(MATCH(A6,week1.xls!$A$1:$A$10,0)), IF(VLOOKUP(A6,week1.xls!$A$1:$D$10,3,0)>VLOOKUP(A6,week1.xls!$A$1:$D$10,4,0),3,0),
--OK, the first part works( i am getting values from an external spreadsheet), it returns the correct numbers (either 3 or 0)
IF(VLOOKUP(A6,week1.xls!$A$1:$D$10,4,0)>VLOOKUP(A6,week1.xls!$A$1:$D$10,3,0),3,0))
--HOWEVER, this part does not work, it returns #N/A, and i really do not know why. I have spent the last hour trying to work it out. Can somebody please help! The formula is now a mess in my head
Thanks a lot
=IF(ISNUMBER(MATCH(A6,week1.xls!$A$1:$A$10,0)), IF(VLOOKUP(A6,week1.xls!$A$1:$D$10,3,0)>VLOOKUP(A6,week1.xls!$A$1:$D$10,4,0),3,0),
--OK, the first part works( i am getting values from an external spreadsheet), it returns the correct numbers (either 3 or 0)
IF(VLOOKUP(A6,week1.xls!$A$1:$D$10,4,0)>VLOOKUP(A6,week1.xls!$A$1:$D$10,3,0),3,0))
--HOWEVER, this part does not work, it returns #N/A, and i really do not know why. I have spent the last hour trying to work it out. Can somebody please help! The formula is now a mess in my head
Thanks a lot