Next, set the dropdown under Allow to List in the dialog box. The Source text box is where we will use the INDIRECT function. Click inside the Source text box and enter the following formula: ...