![]() ![]() Just 14 and up do not work and return the 502 error. ![]() =IF(H6=0,"",(VLOOKUP(H6,$'Data Lookup'.A:$'Data Lookup'.M,14,0)))Įverything stating M.13.0 and less (down to M.2.0, since M.1.0 is the initial search criterion) works perfectly. I’ve literally copy-n-pasted the VLOOKUP argument so I know it’s identical, except for the column from which it’s pulling that cell’s requested data. Huh… I honestly don’t see anything “wrong” with it. Carefully checking your spreadsheet to find out about the error and assessing the arguments is the recommended way to solve this problem. If you are using VLOOKUP and trying to return some value from the column, but the column number doesn’t exist in the selected table, you will get Error 502.Īlmost all functions can return Error 502 if you pass an invalid argument.Because it expects a positive number, and you are passing a negative. If you pass a negative number to SQRT (square root) function – Error 502 will be thrown by Calc.Likely you are providing some incorrect argument that is causing this error. How to fix Err 502Ī typical way to fix this error is – to check each and every function and its parameters which you are passing. It can happen to any function if you pass invalid arguments it was not supposed to receive. As the Calc manual says – it occurs when – “A function argument has an invalid value or invalid function argument”. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |