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

When should you use TRUE in vlookup?

You can use TRUE as the last argument in vlookup function when you are looking up using which is a range with a lower limit and an upper limit. For example if you want to charge a customer according to...

Akhilesh Dadhich

0 0

Conditional formatting with formulas

Conditional formatting quickly formats information in a spreadsheet. But sometimes the biult in rules are not enough. Adding your own formula to a conditional formatting rule gives it a power to help you do custom things.

Sharad Singh

0 0

Concatenate Function

Concatenate , one of the text functions, to join two or more text strings into one string. The Excel Concatenate function joins together a series of supplied text strings or other values, into one combined...

Saburudeen Ma

0 0

How to do Advanced filter in Excel

Ujjal Goswami

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.