4.14 out of 5
1419 reviews on Udemy

How to use Vlookup in Excel – A simplest tutorial

Learn Lookup functionality in just 50 minutes
Nurture Tech Academy
18,042 students enrolled
English [Auto-generated]
How to use references, Vlookup, Hlookup, Lookup, Index & Match
Learn whole lookup functionality from Microsoft Certified trainer from your own desk.
Suitable for beginners to advanced users. ideal for users who learn faster when shown.
Functions explained in most logical and simplest manner
Downloadable exercise files for practical learning

In this lookup functionality video course, Nurture Tech Academy introduces you to the most simplest way to understand Vlookup and other lookup functions.

In this Excel training course, you will learn by watching the author actually perform the operation he is instructing on, as he explains step by step how to perform these functions. The training starts with understanding references and how excel reacts on the same. Then it will show you how to use Vlookup and then gradually moves to the next level in lookup functionality like Vlookup with False, Vlookup with True, Vlookup with if function, Hlookup, Lookup and ultimately combines Index & Match.

By the completion of this online training course, you will be fully versed, and capable of using any function in lookup functionality in Microsoft Excel 2007/2010/2013 in a commercial Environment.

First thing first - References in Excel

4 types of references

In this lecture we will cover 4 types of references. It is really important to know how excel reacts on references. The references available in excel are as follows:-

1. Relative Reference - In this case if you refer a cell address it will not follow that address strictly i.e. it will change if you copy and paste the same on another cell.

2. Absolute Reference - In this case it will follow the same cell address everywhere when we copy and paste the same.

3. Mixed Reference - Under Mixed reference, we can either freeze a column of a row whenever we refer a cell.

4. 3D Reference - Whenever we refer a cell on a different sheet or a different workbook it is known as a 3D reference.

Understanding Vlookup in-depth

Vlookup with False

You can use the VLOOKUP function to search the first column of a range of cells, and then return a value from any cell on the same row of the range. In this lecture we will learn how to use Vlookup with False or Exact Match. Whenever we have values exactly available in our lookup range we can use Vlookup with False. This will help us to get the final result.

Vlookup with True

In the earlier lecture we have learnt how to use Vlookup with False when we have exact lookup values available but what if, we have some approximate values available for lookup. In that case we can use Vlookup with True. We can either choose True from the dropdown list or we can write 1 in that argument. Both will work fine.

Vlookup with Mixed References

In this lecture we will cover how to use vlookup with Mixed Reference. Let me tell you guys this will help a lot in saving time while working because a number of times we face a situation in which we have to lookup the values from a data range but we have to keep either column or row to be freeze for further references. If you are not clear about how to use Mixed Reference then i'll advice you to please go through with the first lecture again and fully verse with references part and then jump into this lecture.

Vlookup with IF functionality - a nested function

With this lecture i assume that you know how to use a logical function like "IF". Let me just give you a brief about IF function that, as per its syntax i.e. (logical_test, [value if true], [value of false]) it judges the condition we give it and on the basis of that it apply the result e.g. if i toss a coin, it will be considered as a "logical_test" , now if i demand heads so this is my condition so if this condition will become true than excel ask us that what we want it to show. It means that i demanded heads so i say that if head comes then this formula will show "You Win" otherwise "You loose" so i'll assign "You Win" to [Value if true] and "You loose" to [Value of false].

So we will club this function with Vlookup and tell excel to lookup values on the basis of some conditions.

Understanding Hlookup

Hlookup - lookup in horizontal way

The Microsoft Excel HLOOKUP function searches for value in the top row of table_array and returns the value in the same column based on the index_number

The syntax for the Microsoft Excel HLOOKUP function is:

HLOOKUP( value, table_array, index_number, [not_exact_match] )

value is the value to search for in the first row of the table_array.

table_array is two or more rows of data that is sorted in ascending order.

index_number is the row number in table_array from which the matching value must be returned. The first row is 1.

not_exact_match is optional. It determines if you are looking for an exact match based on value. Enter FALSE to find an exact match. Enter TRUE to find an approximate match, which means that if an exact match if not found, then the HLOOKUP function will look for the next largest value that is less than value. If this parameter is omitted, HLOOKUP will return an approximate match.

Lookup - No "V" No "H" only lookup

Only Lookup

In this lecture we will see how to use lookup.

The Microsoft Excel LOOKUP function returns a value from a range (one row or one column) or from an array. There are 2 different syntaxes for the LOOKUP function:

In Syntax #1, the LOOKUP function searches for value in the lookup_range and returns the value in the result_range that is in the same position.

The syntax for the Microsoft Excel LOOKUP function is:

LOOKUP( value, lookup_range, [result_range] )

value is the value to search for in the lookup_range.

lookup_range is a single row or single column of data that is sorted in ascending order. The LOOKUP function searches for value in this range.

result_range is optional. It is a single row or single column of data that is the same size as the lookup_range. The LOOKUP function searches for the value in the lookup_range and returns the value from the same position in the result_range. If this parameter is omitted, the LOOKUP function will return the first column of data.

Last option in Lookup Functionality - Index & Match

Index and Match - The power of two

When deciding between which vertical formula to use in excel, the majority of Excel experts agree that Index & Match is a better formula than Vlookup. However, many people still resort to using VLOOKUP because it’s a simpler formula. One major driver of this problem is that most people still don’t fully understand the benefits of switching from VLOOKUP, and without such an understanding, they are unwilling to invest the time to learn the more complex formula.

In this lecture i'll explain you the advantage of using Index and Match togather.

You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
4.1 out of 5
1419 Ratings

Detailed Rating

Stars 5
Stars 4
Stars 3
Stars 2
Stars 1
30-Day Money-Back Guarantee


1 hours on-demand video
Full lifetime access
Access on mobile and TV
Certificate of Completion

Custom Sidebar

This theme offers completely unlimited custom sidebars down to the individual post and page level. For this specific sidebar:

  1. Go into Theme Options >> Custom Sidebars and create a new sidebar
  2. Go into Appearance >> Widgets and find the new sidebar you created and add widgets (for instance this is a standard text widget)
  3. Go to any page or post and choose the custom sidebar in the layout options
Latest Reviews
Try a different filter
Top Ten This Week
[Udemy] The Complete Angular 9+ Course for Beginners (Step by Step)
[Udemy] Full Stack Web Developer with AI & ML Integration|Hindi|Urdu
[Udemy] Unity Game Development: Create A 3D Beat Em Up Game
[Udemy] CCA Hadoop & Spark Developer Practice Test (CCA175)-2019
[Udemy] Create Multi Level Marketing Website – MLM with WordPress

[Udemy] Unity game development, make games in just 4 hours
[Udemy] Learn Python Programming for Absolute Beginners
[Udemy] Create a web application with python + Django + PostgreSQL
[Udemy] ArchiMate 3.0 Crash Course
[Udemy]REST WCF Service in ASP.NET

WP Twitter Auto Publish Powered By : XYZScripts.com
Skip to toolbar