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

HOW TO USE INDIRECT FUNCTION IN EXCEL ?

Table of Contents INTRODUCTION PURPOSE OF INDIRECT FUNCTION IN EXCEL PREREQUISITES TO LEARN INDIRECT FUNCTION SYNTAX: INDIRECT FUNCTION IN EXCEL …

EXCEL FUNCTIONS- CHOOSE

Table of Contents INTRODUCTION PURPOSE OF CHOOSE FUNCTION IN EXCEL PREREQUISITES TO LEARN CHOOSE SYNTAX: CHOOSE FUNCTION EXAMPLE: CHOOSE FUNCTION …

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 …

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 …

EXCEL FUNCTIONS-VLOOKUP

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

CONVERT ROWS TO COLUMN OR COLUMN TO ROW USING TRANSPOSE FUNCTION IN EXCEL

Table of Contents PURPOSE OF TRANSPOSE FUNCTION IN EXCEL PREREQUISITES TO LEARN TRANSPOSE FUNCTION SYNTAX: TRANSPOSE FUNCTION IN EXCEL EXAMPLE …

EXCEL FUNCTIONS-MATCH

Table of Contents INTRODUCTION PURPOSE OF MATCH IN EXCEL PREREQUISITES TO LEARN MATCH SYNTAX: MATCH FUNCTION EXAMPLE :MATCH FUNCTION IN …

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

Table of Contents INTRODUCTION PURPOSE OF INDEX FUNCTION IN EXCEL PREREQUISITES TO LEARN INDEX SYNTAX: INDEX FUNCTION MULTIPLE SEARCH RANGES …