UrbanPro
true

Find the best tutors and institutes for Microsoft Excel Training

Find Best Microsoft Excel Training classes

Please select a Category.

Please select a Locality.

No matching category found.

No matching Locality found.

Outside India?

Vlookup is old, use Index Match function

Ayush Agarwal
26/11/2019 0 0

Vlookup function has the below limitations.

1. The lookup range should always be on the right-hand side of the vlookup value. This is the biggest limitation.

2. If supposedly you need to look up a value from say 90th column, then lookup function is designed in such a manner that in the background it will search in all the columns before the 90th column and then give you the result from the 90th column. This takes a lot of time if the file size is huge.

INDEX MATCH helps to solve the above problems.

No need to worry whether lookup range is on left or right, you can directly use the Index Match function and get your result at a better speed as compared to Vlookup.

 

 

0 Dislike
Follow 1

Please Enter a comment

Submit

Other Lessons for You

Advanced Excel and VBA concept
In this video, learn about Advanced Excel: - Data Input and Hidden Features, - Worksheet Navigation, - Excel Formulas & Functions, - Data Cleaning and Formatting. VBA and its useful Built-in Functions,...

Nagadarshan | 06 Jul

0 0
0

Data Analysis with MS Excel Filter - Top Performers, Bottom Performers, Above Average Performers, Below Average Performers!
In the following, You would find lesser-known, unexplored yet Powerful Features of Filter. Please refer to sample dataset below: To do Data Analysis:Step 1) Apply Filter on the dataset.Step 2) In Sales...

Ankur Sharma | 02/07/2020

1 0
0


How to Insert a Pivot Table.
Let's learn how to Insert a Pivot Table.

Amey Vidvans | 22/04/2020

0 0
0

Tips - How to put PivotTable Field List back at its Original Position?
Have You ever struggled to put PivotTable Field List back at its Original Position?*Original Position - right-side of the worksheet, as highlighted in the following picture: If Your answer is Yes, You...

Ankur Sharma | 01/04/2020

2 0
1
X

Looking for Microsoft Excel Training Classes?

Find best tutors for Microsoft Excel Training Classes by posting a requirement.

  • Post a learning requirement
  • Get customized responses
  • Compare and select the best

Looking for Microsoft Excel Training Classes?

Find best Microsoft Excel Training Classes in your locality on UrbanPro

Post your learning requirement

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 7.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more