INDIRECT

Definition: INDIRECT is a function that returns a reference to a range based on a text string.

Syntax: =INDIRECT(ref_text, [a1])

Situation: This formula is suitable when you need to return a reference to a range based on a text string.

Example: If you have a table of sales data, and want to find the sales for a particular product in quarter 3, the formula =INDIRECT(“E”&ROW()) can be used.