Indirect

Updated: 11/12/2023 by Computer Hope

Indirect may refer to any of the following:

1. In general, indirect describes something that's not straight or the most efficient path. For example, when driving to a destination, if you took a detour, it would be the indirect route.

2. In Microsoft Excel and spreadsheets, INDIRECT is a function that returns a reference specified by a text string. For example, the formula below returns the value of a random cell between A1 and A10 using the indirect and randbetween functions.

=INDIRECT("A"&RANDBETWEEN(1,10))
Tip

See the following link for further examples and information with this function.

Indirect address, Spreadsheet terms