seems I can’t get VLOOKUP work with a dropdown menu of 16 elements, since the VLOOKUP outputs an “#N/A” as result everytime I select, from my dropdown menu, the 9th (in one situation) or 10th (in another) element of the list.
Accordingly to this thread (Vlookup not working on large data), Calc has a limit when handling VLOOKUP, but this limit is over 2k rows, while I have this issue when I do not eve hit the 10th.
I have reviewed the formula over and over and I can’t find the error, if there’s any (and there must be one, after all, if the output is “#N/A”).
Thank you for the help you will provide.
EDIT 180921-02:27CET: apparently, on a search, only THREE entries are broken (two sequentials, and the last one). On the other search, at least TWO out of 16 are not working (the one I need, and one two selections after).
I do not understand why there’s this yes/no working thing where it should just work or not.
Attaching the (someway) compiled file to help you sort things out.
LV’s OGame Manager v180920-LV.ods
The VLOOKUPs not working are:
TAB “BunkervsRIP”, “Chosen Planet”: “Imperivm” and “Legio X”
TAB “Planner”, “Fake Research”: “Computertech”, “Astrophysics” and “Armour”