Hi
I have created the below formula to link weekly information into a weekly summary spreadsheet, columns C and D contain a list of people. My formula works but in some circumstances where people are not included in one week the formula will return a #value! error. I have tried using ISERROR at the beginning of the formula but this only returns 0 in all cases.
=IF(VLOOKUP(C1,'[Weekly.xls]Week1'!$C:$D,1,FALSE),VLOOKUP(C350,'[Weekly.xls]Week1'!$C:$M,11,FALSE),"0")
Any suggestions on how this error can be removed?
Thanks
I have created the below formula to link weekly information into a weekly summary spreadsheet, columns C and D contain a list of people. My formula works but in some circumstances where people are not included in one week the formula will return a #value! error. I have tried using ISERROR at the beginning of the formula but this only returns 0 in all cases.
=IF(VLOOKUP(C1,'[Weekly.xls]Week1'!$C:$D,1,FALSE),VLOOKUP(C350,'[Weekly.xls]Week1'!$C:$M,11,FALSE),"0")
Any suggestions on how this error can be removed?
Thanks