Microsoft Excel's Data Validation tool lets you add a drop-down list to a cell based on existing data in a column. However, how this works depends on whether the source data is part of a formatted ...

The INDIRECT function is a great way to create links ... you could add drop-down menus using Excel's Data Validation tool. In ...

Use Excel data validation to prevent duplicate values ... You don’t have to know exactly how the INDIRECT() function works, but briefly, it returns the reference as text. Without this function ...

then click Data Validation. From the Allow drop-down list, choose List. In the Source box, type an equal sign and INDIRECT function, referring to the first data cell in the Produce Type column ...