Forum Discussion
TomerBA
Jun 10, 2020Copper Contributor
Data completion
hey, i have couple of questions : i would like to know how can i make my workbook to compute the next example column A contains a TV type - that have been selected from a list - Data authentication...
SergeiBaklan
Jun 10, 2020Diamond Contributor
It looks like you need to use dependent drop-down lists technique, sample is here https://www.excel-easy.com/examples/dependent-drop-down-lists.html and you may google for more tutorials.
- TomerBAJun 10, 2020Copper Contributor
i did all the steps as ritten, when i try to do the INDIRECT function i get an erorr,
"the original value is an error, would you like to continue?"
when i click "YES" i get no drop-down list