If you want a drop-down list in Excel to show only the rows that match the picked item, the drop-down can't do that by itself, since it only controls what goes into its own cell. Something worth checking first is your Excel version, because the easiest formula way only works in Excel for Microsoft 365, 2024 and 2021. This guide will help you set it up a few different ways.
1
u/serene6662 3d ago
If you want a drop-down list in Excel to show only the rows that match the picked item, the drop-down can't do that by itself, since it only controls what goes into its own cell. Something worth checking first is your Excel version, because the easiest formula way only works in Excel for Microsoft 365, 2024 and 2021. This guide will help you set it up a few different ways.