Answer the question
In order to leave comments, you need to log in
How to fill cells in google sheets automatically when choosing a value from a drop-down list?
I have 2 tables on different sheets, on the first one I display the value of some parameter with formulas (as a result, a simple table in 2 columns), on the second I want to make a droplist of the list of these parameters (column 1 of the first table), and so that in the next cell automatically the corresponding value was substituted (column 2 of the first table).
The droplist is done in an elementary way, but how to substitute the corresponding values from neighboring cells?
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question