Excel's INDIRECT function turns a text string into a reference ... Now, let's look at using the INDIRECT function to reference a cell in another sheet. Cell A1 of Sheet2 contains the number ...