none
Excel sum vlookup error RRS feed

  • Question

  • How can I get this statement to work.
    =SUM(IF(ISNA(VLOOKUP(CONCATENATE($A8,E$2),Download!$H$1:$V$2000,$D$1,0)),"",-VLOOKUP(CONCATENATE($A8,E$2),Download!$H$1:$V$2000,$D$1,0))+IF(ISNA(VLOOKUP(CONCATENATE($A8,E$2),DownloadNZ!$H$1:$V$2000,$D$1,0)),"",-VLOOKUP(CONCATENATE($A8,E$2),DownloadNZ!$H$1:$V$2000,$D$1,0)))

    It works ok when it finds the cell its looking for but if it doenst exist it gives
    #VALUE!
    Monday, March 1, 2010 8:07 AM