Forum Discussion
JaneeCam
Oct 31, 2023Copper Contributor
How to make auto populated cells change accordingly when I select from a drop-down menu?
Hi, I have a template I am working on with many sheets. I am working on tweaking a dashboard sheet "Contacts Tracker Dashboard" based off data in another sheet "Contacts Tracker Database". I ha...
Vinod2406
Oct 31, 2023Brass Contributor
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
JaneeCam
Nov 01, 2023Copper Contributor
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!