Excel 2024 Indirect Characterization. Learning how to use the indirect function in excel can make your spreadsheets more dynamic. Generating multiple formula columns, creating complex formula columns that span across multiple tables, and new ways to engage with.

Goals is to form a table form few different files. You can use a cell reference in the indirect() function, which resolves to the value in the referenced cell.