Forum Discussion
How to make auto populated cells change accordingly when I select from a drop-down menu?
If you don't mind could you please share sample data .
Hi thanks so much for taking a look at this.
Yes. For some reason it wouldn't let me attach the excel so I tried to take some pictures.
Please let me know if this makes sense or needs further explaining.
For example, when I choose John Doe from the drop-down list. I get the test data auto populated accordingly.
However, next to this Ideally I would like to have an interactive table. So when John Doe is selected from the above drop-down list, he appears here like so. The email may auto populate as well as shown here. However, I would like to be able to then edit/add dates (such as the test ones here) that will only show when "john doe" is selected. So if "jane doe" was selected next, then this table would only reflect the related data. For example the test dates I have in here now stay the same no matter who is selected. Additionally, I would like to do this for "employee" so it can easily be chosen (from that related drop-down menu) and then stay there for that one "contact" such as john doe and then change when I select a new contact. and same for "message", if i were to add texts there too.
Hope this helps! 🙂 thanks again!
Hi,
Thanks for the data.
The dropdown can be placed using data --> data validation --> allow list
Other details can be mapped using Lookup function.
Sample solution attaching FYR
So sorry for the delayed response! Thanks so much for the advice! So, it seems that there has to be a source data table that can be edited and the solution dashboard has to be linked and won't be editable. The XLOOKUP formula also seems to produce similarly to the QUERY formulas I was using before for that kind of outputs. Do you recommend one over the over?
In all it was super helpful! Thanks so so much!
