VLookup

How to use VLookup Match function in Excel

VLookup Match one of the most powerful and important function in Excel. Sometime we need to use VLookup and Match function together to lookup specific value. If you need better control over during lookup and match the value then you must have to know how to use VLookup Match function in Excel. This dynamic function allows you to reduce the chances of error and improve the capability of VLookup function. Read More

How to use Double VLookup in Excel

If you have data in two different table or worksheet then you need to apply double VLookup in Excel. At this situation most the Excel user face lot of issue how to get the exact result which match the condition. This article helps you to know how to use Excel Double VLookup function in active worksheet. Read More

Excel VLookup Find First, 2nd Or Nth Match Value in Excel?

If you have more than one columns and want to use Excel VLookup to find first, 2nd or Nth match value in Excel. Normally it’s not easy to do this job but after reading this article you can easily find out first, 2nd or Nth match value in Excel sheet. All we know VLookup is a powerful lookup function which is located in lookup and reference category. Read More

How to use VLookup with Min Function to get lowest value

If you have a large worksheet data and want to get the lowest value in any column then you must have to use VLookup with Min Function to get lowest value in active worksheet. VLookup function with Min Function allows you to get the lowest value from the list of range. Most of the person have to face this kind of problem but after reading this guide you can easily get the proper solution of your query. Read More

VLookup to return multiple column values

VLookup is an important Lookup and Reference function which allows you to prepare different types of MIS reports. You can use VLookup to return multiple column values at once without any extra effort. During using the VLookup function you must have to again and again type VLookup function to view next column values. But after reading this trick you can quickly view rest of columns values which is based on the lookup value with the help of VLookup function. Read More

Reverse VLookup in Excel with VLookup Function

Most of the person don’t known about the reverse VLookup in Excel. All we know very well VLookup is an important lookup function which search the value from left to right in given array or table. But sometime you need to lookup the value in reverse order that means right to left. It is not so easy to search the required value in reverse order. But there is no need to worry this guide helps you to know how to use reverse VLookup in Excel with the VLookup function. Read More

How to use index and match functions for advanced lookup in Excel

Hi, today we are talking on Index and Match most popular and powerful function in Microsoft Excel. You can use index match function in excel separately or with combination of other functions as per your need. In this guide we have to discuss how to use index and match functions for advanced lookup in Excel. Index and Match and VLookup functions found in the Lookup and Reference category.  Read More