Dropdown list fails to collect data
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!