Note: INDIRECT is avolatile functionand can cause performance problems in larger or more complicated workbooks.
you’re able to use INDEX to retrieve individual values, or entire rows and columns.
MATCH supports approximate and exact matching, andwildcards(* ?)
INDIRECT is useful when you want to assemble a text value that can be used as a valid reference.
