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 …