![use in formula drop down box excel 2016 for mac use in formula drop down box excel 2016 for mac](https://www.excelcampus.com/wp-content/uploads/2014/11/Excel-Drop-down-List-Always-Visible-Hyperlink-Formula.png)
If it doesn't work for you, try embedding drop down controls instead.įigure A shows a simple matrix-type data set listing representatives in each of the four regions. Once we're done, you'll see that this solution isn't perfect, but it is super easy to implement. If you Google, you'll find complex and sometimes even convoluted solutions. I'm showing the simplest technique, but it's not the only technique. Note: This technique works only with a matrix-style data set. You can work with your own data or download the demonstration. A situation like that requires two drop downs: One that lets you specify the region, and the second that displays only the staff in that region. You want to work with personnel by region, not all personnel. Let's suppose you have personnel scattered across four regions: North, south, east, and west.
![use in formula drop down box excel 2016 for mac use in formula drop down box excel 2016 for mac](https://i.ytimg.com/vi/P_KolUyncNU/maxresdefault.jpg)
You can use a Microsoft Excel drop down list to display a simple list, though sometimes you need a bit more control. Windows 11: Tips on installation, security and more (free PDF).
Use in formula drop down box excel 2016 for mac windows 10#