There are several functions can do data referencing: LOOKUP, VLOOKUP, HLOOKUP, MATCH, INDEX, and OFFSET. VLOOKUP and HLOOKUP are partly covered in this article (VLOOKUP and HLOOKUP functions). OFFSET function is covered in another article (Dynamic Referencing for Excel). This article primarily focuses on
Dominate Your Excel Spreadsheets
Gain the edge and take your Microsoft Excel skills to the next level. Learn the necessary skills to supercharge your workflow with powerful formulas and functions.