Excel VLOOKUP

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 »

How to Compare Two Lists in Different Worksheets using VLOOKUP in Excel

This post will guide you how to compare two lists in different worksheets in Excel. How do I compare two lists in different worksheets with VLOOKUP function in Excel 2013/2016. Comparing Two Lists in Different Worksheets Assuming that you have two lists of data in the different worksheets, and you want to compare those two… read more »

How to Look up Value and Return Adjacent Cell Value in Excel

This post will guide you how to lookup a value from a range of cells and return match from adjacent cell in Excel.  How do I Vlookup a value and return a value in corresponding, adjacent cell in Excel. Look up Value and Return Adjacent Cell Value Assuming that you have a list of data… read more »

How to Get the First, 2nd or Nth Match Using Vlookup/Index/Match

This post will guide you how get the nth matching values with VLOOKUP function in Excel. How do I find the nth match value with Index/Match formula in Excel. How to find the first, second, third or nth matching value from a range of cells using VLOOKUP formula. Find the First Match Value Using VLOOKUP… read more »

VLOOKUP Returns zero instead of #NA in Excel

This post will guide you how to VLookup and return zero instead of #N/A in Excel. How do I use VLookup function and return zero instead of #N/A if not found in Excel. How to display zero instead of #N/A when using VLOOKUP in Excel. How to replace #N/A with Zero when VLOOKUP. VLOOKUP Returns… read more »

Find Unique Values in Two Columns

This post will guide you how to find unique values in two columns in Excel. How do I find unique values between two columns with a formula in Excel. How to display only unique values from two columns in Excel. Find Unique Values Assuming that you have a list of data in two different columns… read more »

Sidebar