Excel Tip: VLOOKUP formula limitations

Karthik Dale

24/05/2017 0 0

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

Hidden Gems of MS Excel - Data Validation - Circle Invalid Data

Q) You apply Data Validation to a range of Cells. e.g. You apply Data Validation Drop-down List of 5 Indian Cities: Indore, Lucknow, Mumbai, New Delhi, Pune, to a range of Cells What if invalid data...

Ankur Sharma

3 1

Arrange and View Multiple Worksheets at Once in Excel

Arrange and View Multiple Worksheets at Once in Excel This feature allows you to view multiple worksheets at once from the same workbook at the same time. You need to follow beneath simple...

Vishesh Golya

0 0

How to generate datasets?

Anyone can easily generate dataset numeric datasets using RANDBETWEEN function. This function generates random numbers between specified values. After using this function you can copy the range to which...

Akhilesh Dadhich

0 0

Hidden Gems Of MS Excel - Auto Fill: Only Weekdays OR Only Months OR Only Years

Fill dates Automatically in worksheet cells. The 1st and 2nd Format are known by Most Excel Users, however, 3rd - 5th Formats are lesser known. 3rd format - Only Weekdays 4th format - Only Months* 5th...

Ankur Sharma

3 0

Advanced Filter in Microsoft EXCEL

ADVANCED FILTRATION PART NAME C Lang. JAVA NAME C Lang. JAVA SAME LETTER NAME CRITERIA ASHU 55 63 A* ...

Vaibhav R.

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

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.