Dropdown list fails to collect data

Ther Tamás shared this question 5 months ago
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!

Best Answer
photo

Unrequested add-on

Comments (3)

photo
2

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.

photo
1

Thanks, Rami! I shall try the way you show!

photo
photo
1

Unrequested add-on

© 2019 International GeoGebra Institute