![]() The sixth sheet is the Data Lookup sheet, and it’s a massive table of store numbers (first field) and then all the other pertinent data for each of those stores (district, phone number, address, and so on). The second, third, fourth, and fifth sheets are weekly result tables which I can print. The first sheet is a data entry sheet, where I type in the store number (along with first day of that week and team members I’m working with), and it’s broken out to give me five days, and then these are grouped into four groups (i.e. Just 14 and up do not work and return the 502 error. I wasted 2 days of restless searches for reasons why it still produce Err:522. =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. Error 522 - according to help, is Circular reference Formula refers directly or indirectly to itself and the Iterations option is not set under Tools - Options - Calc - Calculate. 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. Other functions can return this error, for example : VAR. Huh… I honestly don’t see anything “wrong” with it. 522 Circular reference A formula makes direct or indirect reference to itself and iterations have not been activated in the Tools Options LibreOffice Calc Calculate menu. 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. ![]() ![]() ![]()
0 Comments
Leave a Reply. |