# MICROSOFT EXCEL FUNCTIONS- LOOKUP AND REFERENCE

### 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.

### LOOKUP AND REFERENCE FUNCTIONS

#### EXCEL FUNCTIONS- CHOOSE

INTRODUCTION Life is full of choices and so is our Excel. Whenever we try to create smart sheets, we always …

#### USE VLOOKUP TO SEARCH CASE SENSITIVE LOOKUP BY MATCHING CASE

INTRODUCTION Case sensitive Vlookup .If you have been working with the vlookup function of the excel for a while, you …

#### HOW TO USE WILDCARD CHARACTERS IN VLOOKUP FUNCTION IN EXCEL

INTRODUCTION VLOOKUP is one of the great functions of Excel. Every Excel learner wants to get perfection over this function …

#### EXCEL FUNCTIONS-VLOOKUP

EXCEL FUNCTIONS-VLOOKUP INTRODUCTION Welcome to the step by step guide to VLOOKUP in EXCEL. The article covers the introduction , …

#### EXCEL FUNCTIONS -TRANSPOSE

Suppose we have a data which needs to be rotated i.e. the rows should become the columns and vice versa …

#### EXCEL FUNCTIONS-MATCH

Looking up for values in reports is one of the most important tasks in EXCEL which we’d be needing to …

#### EXCEL FUNCTIONS-LOOKUP

LOOKUP FUNCTION comes under the LOOKUP AND REFERENCE group of functions in Excel. LOOKUP FUNCTION facilitates us to find a …

#### EXCEL FUNCTIONS-INDEX

INDEX FUNCTION comes under the LOOKUP AND REFERENCE group of functions in Excel. INDEX FUNCTION returns the value of a …