Excel VLOOKUP

If you’re new here, you may want to subscribe to my RSS feed. Thanks for visiting!When using Vlookup you may find it difficult to uncover some of the underlying principles. You don’t find them in the help section, you find them in forums, but opinions tend to be contradictory or not so clear.
Here I will [...]

Excel does not allow you to configure a Vlookup multiple columns but you can do it, using a trick.
I will show it to you now…
The trick is to create a column that joins two or more columns into one.
Here’s the exact method…
Imagine you want to know the Sales of Louis in February,  in the table [...]

Here I will show you 3 simple tactics you can use to copy a vlookup effectively…
1) Set the table_array reference to absolute before you copy Vlookup.
Use F4 or manually add the $ signs to the table_array reference. Failing to do this will lead you to have a data set wrong and unexpected #N/A errors.
For example: [...]

Here you will get one of the most important pieces of Vlookup help…
Most users focus on learning the formula arguments and the syntax, but the main causes of headaches for Excel users is a Vlookup not matching.
This occurs mainly due to the oversight of 2 very basic concepts of Excel vlookups…
1) Vlookup look up the [...]

Pay attention to these 3 golden rules when you Vlookup text in Excel…

Vlookup will return a #NAME? error if the text you are looking up is not quoted in the formula
Vlookup will return a #N/A if the text you are looking up contains extra spaces in the index column
Vlookup will return a #N/A if the [...]

There is some confusion about the Vlookup true, here you will learn 3 handy scenarios where you can use it…
First let me explain very quickly the main differences between a Vlookup true (approximate match) and a Vlookup false (exact match)…
Vlookup true

It looks up the exact match, if it doesn’t find it, then looks up the [...]

There is some confusion about the Vlookup false, here you will learn 4 practical scenarios where you can use it…
First let me explain  very briefly,  the difference between a Vlookup false (exact match) and Vlookup true (approximate match)…
Vlookup false

It looks up the exact match for the given input. For example: if you lookup the [...]

Pay attention to these 3 golden rules when you Vlookup numbers in Excel…

Vlookup will return a #N/A if the number you are looking up does not have the same number of digits as the number in the backend index column
Vlookup will return a #N/A if the number you are looking up is stored as text [...]

The Microsoft Excel Vlookup function can be used in several places, the more creative uses you give it, the more efficient your work becomes.
This article is intended to give you some ideas for practical Vlookup uses…
The Microsoft Excel Vlookup allows you to get a corresponding value for a given input. So where you have an [...]

I will show you here the 4 key concepts you need to crack the vlookup definition. Failing to master one of these concepts will make your life a struggle at work…
Before that, let’s take a look at the big picture
Vlookup is a Lookup function, these types of Excel formulas allow you to extract information from [...]