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 …
Read More

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 …
Read More

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 …
Read More

HOW TO USE VLOOKUP APPROXIMATE MATCH IN EXCEL

INTRODUCTION FOR THE LEARNING VLOOKUP CLICK HERE.(FOR VLOOKUP IN HINDI CLICK HERE).IN THIS ARTICLE WE WOULD LEARN ABOUT THE CONDITIONS …
Read More

EXCEL FUNCTIONS-VLOOKUP

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

EXCEL FUNCTIONS -TRANSPOSE

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

EXCEL FUNCTIONS-MATCH

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

EXCEL FUNCTIONS-LOOKUP

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

EXCEL FUNCTIONS-INDEX

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

EXCEL FUNCTIONS-HLOOKUP

HLOOKUP is as advanced level function. But advanced doesn’t mean tough. In this article we’ll try to find out what …
Read More