VLookup

Lookup Multiple Fields of Data with Excel VLOOKUP

With the combination of Excel VLOOKUP function with the Column, Column and array function you can easily create a lookup formula which allows you to quickly lookup multiple fields of data with Excel VLookup function. Excel VLookup function with array or column function easily return multiple values from a single row of a database or array of table. Read More

How to use IFNA with VLookup function

If any lookup values does not found in the list of array an error message #NA display in the resulted cells. If you want to remove an error value during lookup the value then you must know how to use IFNA with VLookup function. Sometimes when the data your are looking for is not found in the list, you will receive #N/A error message. Read More

Triple VLookup with Index Match function in Excel

Sometime we need to apply triple VLookup in active worksheet and want to get the result which fulfil all given three criteria. In that situation you must have to use Index Match function at the place of applying VLookup function in active worksheet. In this article we have to discussion how could you easily apply triple VLookup with Index Match function in active worksheet. Read More

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. 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 Find First, 2nd Or Nth Match Value. 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