Excel VLOOKUP - Free Excel Tutorial

Get Employee Information by VLOOKUP

VLOOKUP is one of the key functions among all lookup & reference functions in Excel. Today, in this article, we will show you the way to apply VLOOKUP to retrieve employee information. I hope this article will help you in your daily work. EXAMPLE The left table contains employee information like HRID, name, age, and… read more »

VLOOKUP with Two Lookup Tables

VLOOKUP is one of the key functions among all lookup & reference functions in Excel. Today we will show you the application of VLOOKUP function when there are two lookup tables. EXAMPLE Table1 and table2 record the rates of Y2020 and Y2021 separately. Rates are increased in Y2021. In “Statistic” table, we want to fill… read more »

VLOOKUP with Multiple Lookup Values

VLOOKUP is one of the key functions among all lookup & reference functions in Excel. It can scan and retrieve data from a static or dynamic table based on your lookup value. It can perform approximate match or exact match by setting lookup matching modes. Today, we will show you the way to use VLOOKUP… read more »

VLOOKUP Data by Date

VLOOKUP is one of the key functions among all lookup & reference functions in Excel. It can scan and retrieve data from a static or dynamic table based on your lookup value. It can perform approximate match or exact match by setting lookup matching modes. Today, we will show you the way to apply VLOOKUP… read more »

VLOOKUP – Retrieve Data from Another Workbook

VLOOKUP is one of the key functions among all lookup & reference functions in Excel. It can scan and retrieve data from a static or dynamic table based on your lookup value. It can perform approximate match or exact match by setting lookup matching modes. Today, we will show you the way to apply VLOOKUP… read more »

VLOOKUP – Retrieve Data from Another Worksheet

VLOOKUP is one of the key functions among all lookup & reference functions in Excel. It can scan and retrieve data from a static or dynamic table based on your lookup value. It can perform approximate match or exact match by setting lookup matching modes. Today, we will show you the way to apply VLOOKUP… read more »

Case Sensitive Lookup with SUMPRODUCT and EXACT

Today, we will show you how to use SUMPRODUCT and EXACT to perform a case sensitive exact match. In this article, we provide a simple example to calculate bonus for employees whose names are case-sensitive. If you meet similar scenarios in your daily work, you can directly use this formula to deal with your problem…. read more »

Basic Grade Calculation by VLOOKUP Function – Approximate Match

In Excel, except combination INDEX+MATCH, we can also apply other functions to search data, for example VLOOKUP function. Like MATCH function, VLOOKUP function is one of Excel lookup & reference functions that can perform approximate match or exact match by setting lookup matching modes. Today, we will show you the way to calculate “Grade” by… read more »

Basic Discount Calculation with VLOOKUP Function

In Excel, except combination INDEX+MATCH, we can also apply other functions to search data, for example VLOOKUP function. Like MATCH function, VLOOKUP function is one of Excel lookup & reference functions that can perform approximate match or exact match by setting lookup matching modes. Today, we will show you the way to calculate discount by… read more »

How to Use VLOOKUP for Approximate or Exact Matches in Excel

This post will guide you how to use VLOOKUP function to look up values based on an exact or approximate match in Excel 2013/2016 or the higher versions. VLOOKUP function can search a range of cells for a specific value or data and if a match is found, and it will return a piece of… read more »

How to Autofill VLOOKUP Correctly in Excel

VLOOKUP function is extremely strong among excel all functions. We often use it in our work for looking up match value. Sometimes when we autofill VLOOKUP we may get some errors. For most situations that’s because the selected range is entered incorrectly or changed automatically during filling process. This tutorial will help you to enter… read more »

How to Lookup Value by VLOOKUP Partial Match in Excel

VLOOKUP function is very strong and we often use this function in our daily life. And we all know that we can use VLOOKUP to get proper value by entering a value which is exactly the same with the lookup value in selected lookup range. If the entered value is not exactly matching the lookup… read more »

How to VLOOKUP with Dropdown List in Excel?

We often use VLOOKUP function to find proper value by certain conditions in excel. And we often create a dropdown list to filter value in excel. If you combine these two features together, it can help us solve a lot of search problems by some conditions, and it will bring us a lot of convenience…. read more »

How to Lookup Values from Right to Left in Excel

This post will guide you how to vlookup values from right to left in your worksheet in excel. How do I look up values to left column with a column in Excel 2013/2016. How to use Vlookup function to extract the corresponding value of the left column in your worksheet in Excel. Lookup Values to… read more »

Sidebar