LOOKUP AND REFERENCE FUNCTIONS
LOOKUP AND REFERENCE group of functions contain very important and widely used functions in Excel.
LOOKUP AND REFERENCE functions help us to lookup for certain values and fetch any data against them from any other table, sheet or workbook. This category helps us to join two or more tables , sheets or workbooks in an effective manner. Simply saying, it saves our time and help us to perform the tasks which would take hours otherwise, within minutes if not seconds.
Here is the list of functions which fall under this category. Click the function for its further details i.e. formula syntax, examples, purpose etc.