Staff Skills academy+
Home » Courses » Microsoft Excel Advanced Certification » Module 32: INDIRECT Function
Module 32: INDIRECT Function
32.1 INDIRECT Function The INDIRECT function in Excel is a lookup formula used to return a value from text that is based on cell references. An INDIRECT reference will not change, and changes are made to cells, rows or columns, even if they are inserted or deleted. For example, the formula =INDIRECT("B1:B50") will always refer to the first 50 rows of column B, even if the rows in that range are inserted or deleted. The formula is written as: =INDIRECT(ref_text) ref_text - A r...
Lessons
- Module 1: Add a Password
- Module 2 : AND Function
- Module 3 : Auto Updating Drop-down Lists
- Module 4 : CEILING Formula
- Module 5 : Charts that Update Automatically
- Module 6 : CHOOSE Formula
- Module 7 : Compare 2 Lists with VLOOKUP Function
- Module 8 : CORREL Function
- Module 9 : Create an Advanced Calculator
- Module 10 : Create a Combo Chart
- Module 11 : Create a Custom Tab
- Module 12 : Create a Pivot Chart
- Module 13 : Create Visual In-cell Indicators
- Module 14 : Create Visual In-cell Indicators with Icon Sets
- Module 15: Customise the Status Bar
- Module 16: DATEDIF Function
- Module 17: DATEVALUE Function
- Module 18: DAVERAGE Function
- Module 19 : DCOUNT Function
- Module 20 : DCOUNTA Function
- Module 21 : Depreciation Formula
- Module 22 : DGET Function
- Module 23 : DMAX Function
- Module 24 : DPRODUCT
- Module 25: DSUM Function
- Module 26: EDATE Function
- Module 27: EOMONTH Function
- Module 28: Find and Replace
- Module 29: FIND Function
- Module 30: INDEX Function
- Module 31: INDEX MATCH Function
- Module 32: INDIRECT Function
- Module 33: Insert Serial Number Automatically
- Module 34: IPMT Function
- Module 35: ISBLANK Function
- Module 36: ISERR Function
- Module 37: ISLOGICAL Function
- Module 38: ISNONTEXT Function
- Module 39: ISNUMBER Function
- Module 40: ISODD Function
- Module 41: Isolate First Name
- Module 42: ISTEXT Formula
- Module 43: LEFT Function
- Module 44: LEN Function
- Module 45: MATCH Function
- Module 46: VLOOKUP Multiple Results at Once
- Module 47: OR Function
- Module 48: PMT Function
- Module 49: REPLACE Function
- Module 50: Select all Cells with Comments
- Module 51: Sparkline Charts in Excel
- Module 52: Straight Line Depreciation
- Module 53: Strikethrough
- Module 54: Sum of Years Depreciation
- Module 55: Timeline in Pivot Table
- Module 56: VLOOKUP with 2 Criteria
- Module 57: VLOOKUP with DropDown List
- Module 58: VLOOKUP with MAX
- Module 59: VLOOKUP with MIN
- Module 60: Watch Window In Excel
