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 ...

How is indirect function used in data validation? On the spreadsheet, select cell C3. On the Ribbon, click the Data tab, then click Data Validation.