Now, let's look at using the INDIRECT function to reference a cell in another sheet. Cell A1 of Sheet2 contains the number 100, and we want to create an INDIRECT reference to that cell in the ...

Enter data into the spreadsheet or use ... the Data tab, then click Data Validation. From the Allow drop-down list, choose List. In the Source box, type an equal sign and INDIRECT function ...