The INDIRECT function then evaluates the text and converts it to a reference. Excel follows the reference and returns the value at the given reference.
Note: if the reference is invalid, or if the workbook referenced is not open, INDIRECT will throw a #REF error. You can catch this error with the IFERROR function and display a custom result if you like.
The INDIRECT function tries to evaluate text as a worksheet reference. In this example, we have Sheet names in column B, so we join the sheet name to the cell reference A1 using concatenation: = INDIRECT ( B6 & "!A1" ) After...
This is a standard use of the VLOOKUP function to retrieve data from the 4th column in a table: lookup value comes from B5 table_array is a reference to a range in an external workbook col_index is 4, to retrieve data from the forth column...
The Excel INDIRECT function returns a valid reference from a given text string. INDIRECT is useful when you want to convert a text value into a valid cell reference.
Excel Formula Training
Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.