Excel's INDIRECT function turns a text string into a reference. This function has several practical benefits: It allows you ...

You apply the conditional formatting using a custom formula and some variation on the INDIRECT function. In addition to specifying the column and row, you also specify the name of the sheet to pull ...

Finally, the INDIRECT function will open up new possibilities for you by allowing you to reference cells indirectly. With INDIRECT, you can create references based on text strings, making it ...

Press Enter to see the result, which is the current sale. There are two other methods to use the INDIRECT function. Method one is to click the fx button on the top left of the Excel worksheet.