true

Learn Excel Macro Training from the Best Tutors

Affordable fees
1-1 or Group class
Flexible Timings
Verified Tutors

Search in

Excel Tip: VLOOKUP formula limitations

Karthik Dale

24/05/2017 0 0 View Comments

1. Vlookup is not case-sensitive

2. If Lookup value has duplicates in the lookup column, then it returns 1st found value

3. Vlookup cannot pull values which are on the left side from Lookup column

4. Vlookup gives inaccurate output if the Lookup table range is huge.

0 Like 0 Dislike

Follow 0

Other Lessons for You

Difference between Find and Search Function in excel

In excel there are two functions which are taking same arguments and return type. SEARCH() --> Search a text within text, Case insensitive Example: Search("t","Management Team") and Search("T","Management...

Umasankar Natarajan

0 0

What are the function categories on Excel?

Function Categories There are many categories of functions in Excel. Each category has specific functions that pertain to that category. Financial: Performs common business calculations including accounting...

Talent Hub Training Institute

0 0

PowerPivot For Excel

PowerPivot is an add-in for Microsoft Excel 2010 that enables you to import millions of rows of data from multiple data sources into a single Excel workbook, create relationships between heterogeneous...

Itech Analytic Solutions

0 0

VBA Fixed And Variable String

VBA (Excel VBA, Access VBA, Word VBA, Outllook VBA, Power Point VBA, MS Project VBA) defined two types of string data type, Fixed string and Variable string. Fixed String: Length is fixed, data beyond...

Umasankar Natarajan

0 0

Common MS Excel Shortcuts to make life easier!

Hi All,I am new to UrbanPro with a passion for learning and teaching analytical tools, MS Excel being the one of them. Excel is one of those master tools which seems untapped to its fullest potential;...

Shruti S.

0 0

Looking for Excel Macro Training ?

Learn from Best Tutors on UrbanPro.

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you

Looking for Excel Macro Training Classes?

The best tutors for Excel Macro Training Classes are on UrbanPro

Select the best Tutor
Book & Attend a Free Demo
Pay and start Learning

Migrate

Class

Subject

Chapter

Migrate to

Concept Solution

Migration Successful

Learn Excel Macro Training with the Best Tutors

The best Tutors for Excel Macro Training Classes are on UrbanPro

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

I am a Student I am a Tutor
Name*	Please enter your full name. Please enter institute name.
Email*	Please enter your email address.
Phone*	Please enter a valid phone number.
Location*	Please enter a pincode or area name.
City*	Please enter city name.
Category*	Please enter category.
Gender*	Male Female Please select your gender.
Email ID/ Mobile No.*	Please enter either mobile no. or email.
Enter Password*	Please enter OTP Please enter Password Sorry, this phone number is not verified, Please login with your email Id.