Answered
I would like to create a project that calculates based on different input data.
I have inserted data to the spreadsheet (numbers and texts as well), and would like to select the proper values based on a dropdown list (like vlookup in Excel). It works fine for a while (in one pc) and then fails. Saying, that the variable is not defined. Also says to "check imput data" (or something similar).
The functions used: SelectedElement, IndexOf, Cell etc.
Would you have some idea, what to do?
Thanks, in advance!
Files:
Faszerk_Pelda.ggb
The same question 
Unrequested add-on
Unfortunately, her file is corrupt (I think..)
Probably because you use an old ggb version
I couldn't solve the corrupt problem. You should delete everything except the table and start over with a higher ggb-Version (527).
Use the command "SelectedIndex()" instead of "IndexOf()".
I personally don't like working with cell addresses. Alternatively, I would convert the selected line into a list.
See attachment.
Unrequested add-on
Comments have been locked on this page!