=AVERAGE(INDIRECT . in cell E2, because we're telling Excel that we ultimately want to find an average, and we're also using the INDIRECT function to tell Excel where to look to calculate this ...

The Excel INDIRECT function is a Lookup and Reference function, and its purpose is to return the reference specified by a text string. You can use the INDIRECT function when you want to change the ...

The real power of dependent drop-down lists comes from using the INDIRECT function in Excel. The INDIRECT function allows you to create a reference to a cell or range based on a text string.

Use Excel data validation to prevent duplicate values in a column ... You don’t have to know exactly how the INDIRECT() function works, but briefly, it returns the reference as text.