Problem description: Steps to reproduce: 1. open a new spreadsheet, 2. in cells A1:A2, enter the array function =N(VLOOKUP(B1:B2,C1:D2,2,0)) Current behavior: the values #N/A,#N/A are returned in A1:A2 Expected behavior: the values 0,0 should be returned. According to the documentation, N() should never return the value #N/A. Platform (if different from the browser): Browser: Mozilla/5.0 (Windows NT 6.0; rv:13.0) Gecko/20100101 Firefox/13.0.1
*** This bug has been marked as a duplicate of bug 53274 ***