Selecting value from column based on dropdown selection
I have a planning sheet with several benchmark date columns. I have a single selection drop down column called Current Benchmark with each of the benchmark date columns included in the selection list. I am trying to create a formula so based on the drop down selected in Current Benchmark, the date of that benchmark will be pulled from the corresponding column. I want this so I can pull it into a report and post it on a Dashboard without needing to list every benchmark date. Any suggestions would be greatly appreciated.
Help Article Resources
Check out the Formula Handbook template!